Return to Excel Formulas List

Add Minutes to Time – Excel & Google Sheets

Download Example Workbook

Download the example workbook

This tutorial will demonstrate how to add minutes to a time in Excel and Google Sheets.

Add Minutes Time Main

Add Minutes

In Excel, time is stored as a fractional value where each 1/24th represents one hour of the day. So each 1/1440 represents one minute of the day (24 hours * 60 minutes/hour = 1440 minutes).



To add a minute add 1/1440 to a time


Add one Minuteor 59/1440 to add 59 minutes:


Add More Minute

Add Minute to Now

To add a minute to the current time, add 1/1440 to the NOW Function:


Add one Minute to Now

Add Minutes Google Sheets

All of the above examples work exactly the same in Google Sheets as in Excel.

Add Minutes Time Google