Build a signed duration from its parts
Turn a minus sign with 49 hours, 30 minutes and 15 seconds into -2.062674 days.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | OR(A8="+",A8="-") | Checks the sign is a plus or a minus. | TRUE |
| 2 | IF(A8="-",-1,1) | Gives -1 for a minus, 1 for a plus. | -1 |
| 3 | (B8/24+C8/1440+D8/86400) | Turns the hours, minutes and seconds into days. | 2.062674 |
| 4 | "Review duration sign" | Shown when the sign is anything else. | Not used for row 8 |
| 5 | IF( … ) | Puts the sign on the days, or flags the row. | -2.062674 |
Excel counts time in days: a day has 24 hours, 1440 minutes and 86400 seconds. The sign covers the whole time, so - with 0 hours and 30 minutes stays negative.
=IF(OR(A8="+",A8="-"),IF(A8="-",-1,1)*(B8/24+C8/1440+D8/86400),"Review duration sign")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 the sign (+ or -), hours, minutes and seconds 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
Keep these results as plain numbers. Excel shows #### for a negative time in a time format.
Microsoft's help: IF function
OTHER ROUTES YOU MIGHT LIKE

Convert durations to days by unit label
90 Minutes → 0.062500 days
Get the template →
Count complete aligned minute blocks
2:30:15 PM to 5:10:00 PM in 15-minute blocks → 9
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 →