Help with time function

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Joseph - 03 Apr 2004 06:51 GMT

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
djoseph11@tampabay.rr.com

Reply to this Message

JE McGimpsey - 03 Apr 2004 06:56 GMT

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

> I NEED HELP...
>
[quoted text clipped - 5 lines]
> David Poe
> djoseph11@tampabay.rr.com

Reply to this Message

Dave Hawley - 03 Apr 2004 09:15 GMT

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

Reply to this Message