Add seconds to a time

You can add (or subtract) a number of seconds 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 minus 200 seconds.
Cell A3 displays the current time minus 200 seconds using the TIME function to return the correct decimal.
Cell A4 displays the current time minus 40 minutes and 50 seconds.
Cell A5 displays the current time minus 40 minutes and 50 seconds using the TIME function to return the correct decimal.
Cell A6 displays the current time minus 3 hours, 15 minutes and 30 seconds.
Cell A7 displays the current time minus 3 hours, 15 minutes and 30 seconds 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:ss AM/PM".

 A
1=TODAY() = Thursday 02 April 2020
2=NOW() = Thursday 02 April 2020 08:00:28
3=A2+(200*(1/86400)) = Thursday, April 02, 2020 08:03:48 AM
4=A2+TIME(0,0,200) = Thursday, April 02, 2020 08:03:48 AM
5=A2+(40/1440)+(50/86400) = Thursday, April 02, 2020 08:41:18 AM
6=A2+TIME(0,40,50) = Thursday, April 02, 2020 08:41:18 AM
7=A2+(3/24)+(15/1440)+(30/86400) = Thursday, April 02, 2020 11:15:58 AM
8=A2+TIME(3,15,30) = Thursday, April 02, 2020 11:15:58 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

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


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