# Calculate day and time duration in Excel

See how an Excel duration formula finds the date difference between a start and an end, then format the result in days, hours and minutes.

You calculate day and time duration in Excel by subtracting a start value from an end value in a spreadsheet and then formatting the result so it reads as days, hours and minutes. A simple subtraction gives you a working duration value, and a format change or a small formula turns that number into something a person can read at a glance. A day calculator in a spreadsheet is useful when you track appointments, handovers or time between two events. 

## Subtract the start from the end 

An Excel duration formula starts with an end value minus a start value, written as a simple subtraction in one cell. Excel stores dates as whole serial numbers and times as fractions of a day, so one subtraction handles both the day difference and the time gap. Type the two values into separate cells and point the formula at those cells so you can change them later. Keep both cells in the same date and time format before you subtract. 

## Read the result as days and hours 

A duration that crosses midnight can show up as a plain number or as a wrapped clock time until you change the cell format. Apply a custom format such as [h]:mm to show total hours beyond one day, or combine days with a time part in one cell. The date difference in whole days comes from subtracting the date parts alone and formatting the answer as a number. Split the remainder into hours and minutes when you want each part to stand out. 

## Turn the number into readable text 

The TEXT function builds a readable sentence from a duration by converting the value into hours and minutes. TEXT treats the duration as a fraction of a day, so multiply by the unit you need before you format it. Rounding the minutes keeps the output tidy when a duration includes seconds you do not need. Check the result against the two input cells, because a wrong format can hide a large value. 

## Questions about Excel duration results 

### How do I calculate the duration of days and time in Excel? 

Excel calculates a duration of days and time by subtracting the start value from the end value in one cell. A format such as [h]:mm shows the total hours across more than one day. For a day count, subtract the two dates and set the cell format to a plain number. The units follow from how you format the answer, not from the subtraction itself. 

### Why does my Excel duration show a wrong time? 

An Excel duration shows a wrong time when the cell format wraps the result at 24 hours or reads the value as a clock time. Brackets around the hour code, as in [h]:mm, tell Excel to count total hours past one day. A negative result also displays oddly, which points to a start value later than the end value. Check the format first, then check which cell is which. 

### Can Excel count days between two dates without the time? 

Excel counts days between two dates by subtracting one date from the other and formatting the result as a number. The time part is ignored when both cells hold dates without a clock time. If the cells hold both, round the result down to drop the leftover hours. That gives the date difference in whole days. 

### What is a day calculator duration used for? 

A day calculator duration shows how much time sits between two moments, such as a request and a handover. A spreadsheet holds the start and end values and recalculates the gap when either one changes. The result helps you see the length of an appointment or the gap before a deadline. It keeps the timing visible in the same place as the rest of your notes.
