How to add minutes to a time in Excel

See it work

The formula is already in D2, filled down to D6. Change any input and the result updates, or edit the formula to experiment.

How it works

In Google Sheets

The same formula works in Google Sheets: =B2+C2/1440. We ran it in Google Sheets mode on the same data and it returns the same results.

Other ways to do it

Each one was run on the same example sheet.

Common mistakes

• =B2+C2 adds C2 days, not minutes.
• Past midnight the result is more than 1, a time on the next day. Format it as h:mm to show the clock time, or use MOD(…,1).

Try it yourself

Same data, empty answer cell. Your formula is graded instantly, then re-checked on changed data, so a typed-in number won't pass.

Related answers

• How to add hours to a date and time in ExcelDivide the hours by 24 and add them: =B2+C2/24. It rolls into the next day when needed.
• How to calculate time worked across midnight in ExcelWrap the difference in MOD: =MOD(C2-B2,1)*24. A negative overnight difference becomes the right number of hours.
• How to calculate working hours between two dates and times in ExcelCount full working days with NETWORKDAYS and trim the first and last day to opening hours with MEDIAN.
• How to check if a time is between two times in ExcelMeasure from the start time with MOD: =IF(MOD(B2-$F$1,1)<MOD($F$2-$F$1,1),"Yes","No"). It works for windows that cross midnight.
• How to combine a date and a time into one cell in ExcelAdd them: =B2+C2. A date is a whole number and a time is a fraction, so the sum holds both.
• How to convert decimal hours to hours and minutes in ExcelDivide by 24 and format the cell as h:mm: =B2/24 turns 7.75 into 7:45.

Functions used: MOD