How to add hours to a date and time in Excel
Formula (Excel and Google Sheets)
=B2+C2/24Divide the hours by 24 and add them: =B2+C2/24. It rolls into the next day when needed.
- Result on the example
- one result per row in
D2, filled down toD6 - Works in
- Every current version
- Google Sheets
- Same formula
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
A day has 24 hours, so C2/24 is the transit time as a fraction of a day. Adding it moves the timestamp forward and rolls into the next day when needed: 10:00 PM plus 9 hours is 7:00 AM the next morning.
=B2+C2/24Result46083.60417
B23/2/2026 8:00The value in B2.
C26.5The value in C2.
C2/240.2708333333The / operator divides.
B2+C2/2446083.60417The + operator adds.
In Google Sheets
The same formula works in Google Sheets: =B2+C2/24. 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.
| Formula | Result | When to use it |
|---|---|---|
| =B2+C2*60/1440 | 3/2/2026 14:30, 3/3/2026 7:00, 3/4/2026 15:45… | Converts the hours to minutes first; the same result. |
| =MOD(B2+C2/24,1) | 12/30/1899 14:30, 12/30/1899 7:00, 12/30/1899 15:45…Different result | Just the arrival clock time, without the date. Time of day only. |
Common mistakes
- TIME(C2,0,0) ignores fractions like 2.25 hours and wraps at 24 hours; dividing by 24 has neither problem.
=B2+C2adds days, not hours.
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.
Add hours to a date and time
D2, add the transit hours to the departure date and time, and fill down to D6.Questions
How do I subtract hours?
=B2-C2/24.
How do I add hours to a time without a date?
The same formula works. Past midnight, format the cell as h:mm or wrap it in MOD(…,1).
Checked by running on 2026-10-30: every formula and result on this page was calculated by the Spreadsheet Practice formula engine, in both Excel and Google Sheets modes.