### 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
All these cells have been formatted with the custom number format "dd dddd mmmm yyyy".

 A 1 =NOW() = Monday, December 02, 2019 07:03 2 =A1+(6/24) = Monday, December 02, 2019 13:03 3 =A1+TIME(6,0,0) = Monday, December 02, 2019 13:03 4 =A1+(8/24) = Monday, December 02, 2019 15:03 5 =A1+TIME(8,0,0) = Monday, December 02, 2019 15:03 6 =A1+2 +TIME(6,30,0) = Wednesday, December 04, 2019 13:33 7 =A1+2 +(6/24)+(30/(24*60)) = Wednesday, December 04, 2019 13:33

#### Built-in Functions

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