Add minutes to a time
You can add (or subtract) a number of minutes 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 date. Custom format "dddd dd mmmm yyyy".
Cell "A2" displays the current date and time. Custom format "dddd dd mmmm yyyy hh:mm:ss".
Cell "A3" displays the current time plus 25 minutes.
Cell "A4" displays the current time plus 25 minutes seconds using the TIME function to return the correct decimal.
Cell "A5" displays the current time plus 4 hours and 75 minutes.
Cell "A6" displays the current time plus 4 hours and 75 minutes using the TIME function to return the correct decimal.
Cell "A7" displays the current time plus 6 hours, 30 minutes and 80 seconds.
Cell "A8" displays the current time plus 6 hours, 30 minutes and 80 seconds using the TIME function to return the correct decimal.
All these cells have been formatted with the custom number format "dddd, dd mmmm, yyyy hh:mm AM/PM".

Builtin Functions
NOW  The serial number of the current system date and time.
TIME  The time as a decimal given an hour, minute, second.
TODAY  The serial number representing today's date.
Related Formulas
Add hours to a time
Subtract minutes from a time
Add seconds to a time
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top