Add hours to time of day

[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.

 

[Bob I]

Actually an hour is 1/24th of a day so "Date Time 1" plus "hours/24" =
"date time 2"

 

[BruceM]

I am apt to overcomplicate things. Seems simple enough now that you have
pointed out that I can just divide by 24. Thanks.

 

[Bob I]

You're welcome, have a great day.

I am apt to overcomplicate things. Seems simple enough now that you have
pointed out that I can just divide by 24. Thanks.