Help with time function

David Joseph · Apr 3, 2004

I NEED HELP...

if cell a1 lets say is 7:00 and I would like to
add 15 minutes to this time in cell a2 what would be the formula.
Everything I seem to try fails.

thanks
David Poe
[email protected]

JE McGimpsey · Apr 3, 2004

One way:

A2: =A1 + TIME(0,15,0)

another:

A2: =A1 + 15/(24*60)

or equivalently

A2: = A1 + 15/1440

or, equivalently

A2: =A1 + 1/96

Dave Hawley · Apr 3, 2004

Hi David

=A1+"0:15"

and format the cell as the wanted time format.

Lots of valuable Excel time and date goodies here:
http://www.ozgrid.com/Excel/ExcelDateandTimes.htm

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

Help with time function

David Joseph

JE McGimpsey

Dave Hawley