Add hours to a time

You can add (or subtract) a number of hours from a time using fractions.
Dates are represented as sequential whole numbers so 1 hour is equivalent to the fraction (1/24).
Times are represented as fractions based on there being 24 hours in a day.
1 Hour is 1/24 = 0.04166
1 Minute is 1/(24*60) = 1/1440
1 Second is 1/(24*60*60) = 1/86400


Cell A1 displays the current time.
Cell A2 displays the current time plus 6 hours.
Cell A3 displays the current time plus 6 hours using the TIME function to return the correct decimal.
Cell A4 displays the current time plus 1 day and 8 hours.
Cell A5 displays the current time plus 1 day and 8 hours using the TIME function to return the correct decimal.
Cell A6 displays the current time plus 2 days, 6 hours and 30 minutes.
Cell A7 displays the current time plus 2 days, 6 hours and 30 minutes using the TIME function to return the correct decimal.
All these cells have been formatted with the custom number format "dddd, mmmm dd, yyyy hh:mm AM/PM".

 A
1=TODAY() = Thursday 02 April 2020
2=NOW() = Thursday 02 April 2020 08:00:28
3=A1+TIME(6,0,0) = Thursday, April 02, 2020 06:00 AM
4=A1+1 +(8/24) = Friday, April 03, 2020 08:00 AM
5=A1+1 +TIME(8,0,0) = Friday, April 03, 2020 08:00 AM
6=A1+2 +(6/24)+(30/1440) = Saturday, April 04, 2020 06:30 AM
7=A1+2 +TIME(6,30,0) = Saturday, April 04, 2020 06:30 AM

Built-in Functions

NOW - The serial number of the current system date and time.
TIME - The time as a decimal given an hour, minute, second.


Related Formulas

Subtract hours from a time
Add minutes to a time
Add seconds to a time


© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top