adding dates and times

  • Thread starter Thread starter dpurvis
  • Start date Start date
D

dpurvis

I have a cell which stores a date and time in the M/D/Y HH:MM format (i
3/14/03 9:00 pm). I want to add a number of hours to this value an
have it reflected in both the time AND the date. I have tried using
TIME but it does not roll the date portion of the value of to the nex
day.

for example

cell a1 = 3/14/03 9:00 pm

if I make a formula in another cell as follows to add three hours t
a1

= a1 + TIME(4,0,0)

I get a value returned of

3/14/03 1:00 am

The time portion is correct but the date is still the same, it did no
roll over to the next day.

Am I doing something wrong? is there a solution to this?


Any help would be appreciated

Dere
 
You have to custom format the formula cell as [h]:mm so
that it rolls over 24 hours. It's something not obviously
blatant to most users. Someone had to tell me about it a
long time ago. :)

HTH
Jason
Atlanta, GA
 
Back
Top