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 = ?
4 Hours is 4/24 =
12 Hours is 12/24 = 0.5
When working with times make sure your cells are formatted with "h:mm:ss AM/PM"


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 8 hours
Cell A5 displays the current time plus 8 hours using the TIME function to return the correct decimal
Cell A6 displays the current time minus 12 hours
Cell A7 displays the current time minus 12 hours using the TIME function to return the correct decimal
Cell A8 displays the current time plus 2 days, 6 hours and 30 minutes
Cell A8 displays the current time plus 2 days, 6 hours and 30 minutes using the TIME function to return the correct decimal

 A
1=NOW() = Wednesday, October 02, 2019 05:49
2=A1+(6/24) = Wednesday, October 02, 2019 11:49
3=A1+TIME(6,0,0) = Wednesday, October 02, 2019 11:49
4=A1+(8/24) = Wednesday, October 02, 2019 13:49
5=A1+TIME(8,0,0) = Wednesday, October 02, 2019 13:49
6=A1+2 +TIME(6,30,0) = Friday, October 04, 2019 12:19
7=A1+2 +(6/24)+(30/(24*60)) = Friday, October 04, 2019 12:19

Built-in Functions

TODAY - The serial number representing today's date.
TIME - The time as a decimal given an hour, minute, second.


Related Formulas

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


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