time formula

[still learning]

Happy fathers's Day

How do I make a formula that adds 5 hours to the current time.
I don't need seconds

I tried =time()+5
I also tried =now()+5... formating the cell with h:mm

I can't think of any other way...Maybe it's too early
Thanks


Mike

 

[MikeWx]

Mike,

Excel stores dates as the number of days since Jan 01, 1900; and and time as a fraction of a day. Each hour is 1/24.

For your question, use the following:

=NOW()+(5/24)

and format as h:mm

Mike

 

[jeffreybrown]

Or

=NOW()+TIME(5,0,0)

 

[T. Valko]

Happy fathers's Day

How do I make a formula that adds 5 hours to the current time.
I don't need seconds

I tried =time()+5
I also tried =now()+5... formating the cell with h:mm

I can't think of any other way...Maybe it's too early
Thanks


Mike

The NOW( ) function includes the date.

=NOW() returns something like this 6/19/2011 10:22:41 AM.

If you only want the TIME portion use this:

=MOD(NOW()+TIME(5,0,0),1)

Format as Time