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

**nje** · 07-11-2012, 10:46 AM

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.
Could you advise please
Thanks

**Miraun** · 07-11-2012, 10:55 AM

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

**BarryTSL** · 07-11-2012, 10:59 AM

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.

**martindwilson** · 07-11-2012, 11:42 AM

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

**BenMiller** · 07-11-2012, 11:59 AM

=E6+0.00347222222222222 formatted as time

Or

=E6+TIME(0,5,0)

**nje** · 07-11-2012, 12:27 PM

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