Help with time function

[David Joseph]

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
(e-mail address removed)

 

[JE McGimpsey]

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]

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 *****