Add seconds to a time

You can add seconds to a time using fractions and the TIME function.

	A
1	=NOW() = Thursday, 05 November, 2026 03:30 PM
2	=A1 + (200*(1/86400)) = Thursday, 05 November, 2026 03:33 PM
3	=A1 + TIME(0, 0, 200) = Thursday, 05 November, 2026 03:33 PM
4	=A1 + (40/1440) + (50/86400) = Thursday, 05 November, 2026 04:11 PM
5	=A1 + TIME(0, 40, 50) = Thursday, 05 November, 2026 04:11 PM
6	=A1 + (3/24) + (15/1440) + (30/86400) = Thursday, 05 November, 2026 06:46 PM
7	=A1 + TIME(3, 15, 30) = Thursday, 05 November, 2026 06:46 PM

Dates are represented as sequential whole numbers so 1 hour is equivalent to the fraction (1/24).
One Hour is 1/24 = 0.04166
One Minute is 1/(24*60) = 1/1440
One Second is 1/(24*60*60) = 1/86400
Times are represented as fractions based on there being 24 hours in a day.
1 - Displays the current date and time.
2 - Displays the current time plus 200 seconds.
3 - Displays the current time plus 200 seconds using the TIME function to return the correct decimal.
4 - Displays the current time plus 40 minutes and 50 seconds.
5 - Displays the current time plus 40 minutes and 50 seconds using the TIME function to return the correct decimal.
6 - Displays the current time plus 3 hours, 15 minutes and 30 seconds.
7 - Displays the current time plus 3 hours, 15 minutes and 30 seconds using the TIME function to return the correct decimal.