Combine seconds and nanos as days
Turn Protobuf Duration seconds and nanos into a signed number of days.
What you'll make

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8/86400 | Whole seconds turned into days: 86,400 in a day. | 2.062674 |
| 2 | B8/86400000000000 | Adds the nanoseconds as a tiny part of a day. | 2.062679 |
Read it left to right. A minus on both fields gives a negative time. Excel counts time in days.
=A8/86400+B8/86400000000000How 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 fields. Paste each row's seconds and nanoseconds 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: Calculation operators in Excel
OTHER ROUTES YOU MIGHT LIKE

Join date and time codes, skip zeros
20261104 + 143015 → November 4, 2026 2:30:15 PM
Get the template →
Read signed day-and-time interval text
-00 00:30:00.000000 → -0.020833 days
Get the template →
Convert year-month intervals to months
+02-03 → 27 months
Get the template →
Show an appointment time as 1:05 PM
13:05:00 → 1:05 PM
Take this route →