how to automatically add 5 minutes to a time (h:mm) in another column

1. how to automatically add 5 minutes to a time (h:mm) in another column

I've searched the forum and the net but although there must be a simple solution, I can't find one.
The problem:

Column E6 onwards is formatted (h:mm) and has times brought in from another sheet.
Column F onwards is also formatted the same but is empty

Starting in E6 with 1.25 in it I would like to see F6 showing the time from E6 plus 5 minutes, I have managed to get all sorts of results but not the correct one.
Thanks

2. Re: how to automatically add 5 minutes to a time (h:mm) in another column

A quick recreate seems like it counts it in terms of days where 1 = 1 day.

1/24/60 *5 = .003472

So F6 = E6 + .003472

3. Re: how to automatically add 5 minutes to a time (h:mm) in another column

You can use - =E6+\$B\$2 where B2 has the value 0:05 in it. (nice to use a cell with a variable in it, incase you ever need to change it) and copy down.

4. Re: how to automatically add 5 minutes to a time (h:mm) in another column

careful with the imported time it may not be exactly what it says, and when you try to do match with it it doesn't match

5. Re: how to automatically add 5 minutes to a time (h:mm) in another column

=E6+0.00347222222222222 formatted as time

Or

=E6+TIME(0,5,0)

6. Re: how to automatically add 5 minutes to a time (h:mm) in another column

Thanks everyone, what a terrific response. No wonder I was having trouble working it out, not as simple as it first appears (to me anyway) I'll have a play with them laterand see how it works out
Thanks again

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1