Convert durations to days by unit label
A value of 90 can mean seconds, minutes, hours or days. The unit column decides.
Download Excel templateMicrosoft 365
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | B8 | Reads the unit label for this row. | "Seconds" |
| 2 | "Seconds",A8/86400 | Seconds: divides by 86,400, the seconds in a day. | 2.062500 |
| 3 | "Minutes",A8/1440 | Minutes: divides by 1,440, the minutes in a day. | Not used for row 8 |
| 4 | "Hours",A8/24,"Days",A8 | Hours: divides by 24. Days stay as they are. | Not used for row 8 |
| 5 | SWITCH( … ) | Uses the part that matches the unit label. | 2.062500 |
Read it left to right. Any other label says Review duration unit. Excel counts time in days.
=SWITCH(B8,"Seconds",A8/86400,"Minutes",A8/1440,"Hours",A8/24,"Days",A8,"Review duration unit")How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- Use your own durations. Paste each value and its unit (Seconds, Minutes, Hours or Days) into the green columns of the Template tab. The days fill in by themselves.
- Move them into your letter. Copy the results. Then use Paste Special and choose Values.
Before you send
Check every row has its real unit; never guess it from the size. Keep the results as plain numbers.
Microsoft's help: SWITCH function
OTHER ROUTES YOU MIGHT LIKE

Count complete aligned minute blocks
2:30:15 PM to 5:10:00 PM in 15-minute blocks → 9
Get the template →
Build a signed duration from its parts
-, 49, 30 and 15 → -2.062674 days
Get the template →
Build a time from hour, minute, second
14 + 30 + 15 → 2:30:15 PM
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →