Add hours to time of day

  • Thread starter Thread starter BruceM
  • Start date Start date
B

BruceM

I'm looking for a way to add hours to a time value, and have the result
calculated as a new time value. For instance, I want to add 30 hours to
7:00, and have the result be 13:00 the following day (I think I got that
right).

The date would need to be part of the calculation. For ease of use I think
it would be best if the date and time are in separate columns. For
instance:

C1 -- Date
C2 -- Time of day
C3 -- Hours (number)
C4 -- Ending time and date

I expect this has been answered at some point, but I can't seem to find the
right search parameters.
 
I am apt to overcomplicate things. Seems simple enough now that you have
pointed out that I can just divide by 24. Thanks.
 
Back
Top