# How to add hours to a date and time in Excel

Divide the hours by 24 and add them: `=B2+C2/24`. It rolls into the next day when needed.

**Excel:** `=B2+C2/24` (Every current version)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D |
| --- | --- | --- | --- |
| Shipment | Departure | Transit (hours) | Arrival |
| SH-201 | 46083.333333333336 | 6.5 |  |
| SH-202 | 46083.916666666664 | 9 |  |
| SH-203 | 46084.572916666664 | 26 |  |
| SH-204 | 46085.229166666664 | 2.25 |  |
| SH-205 | 46086.760416666664 | 48 |  |

Formula in D2, filled to D6: `=B2+C2/24`

Result: 3/2/2026 14:30; 3/3/2026 7:00; 3/4/2026 15:45; 3/4/2026 7:45; 3/7/2026 18:15

## 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.

## Other ways

- `=B2+C2*60/1440`: Converts the hours to minutes first; the same result.
- `=MOD(B2+C2/24,1)`: 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+C2` adds days, not hours.

## 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).

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/add-hours-to-a-date-and-time