Convert seconds to Excel time (Seconds / 86400) & HH:MM:SS over 24 hours

Why 86,400 is the magic divisor—and how to avoid 24-hour clock rollover!

Telephony ACD exports, cloud CPU billing logs, and video encoders report durations in raw seconds (e.g., 3,725 seconds). Because spreadsheet times are fractional days and 1 day = 24 * 60 * 60 = 86,400 seconds, dividing Seconds / 86400 converts raw seconds directly into an Excel time serial!

Watch out when cumulative queue time exceeds 86,400 seconds (24 hours): standard clock HOUR() wraps 25 hours back to 01:00! Decomposing total seconds via h = INT(s / 3600), m = INT(MOD(s, 3600) / 60), and sec = MOD(s, 60) formats both 01:02:05 (3,725 s) and 25:01:05 (90,065 s) without ever losing a day!

Format raw seconds into rollover-proof HH:MM:SS (even above 24 hours)

Pads single-digit hours to 2 digits ("01") while preserving 2+ digit hours ("25", "120") intact.

This text formatter rounds nonnegative seconds to the nearest whole second before splitting hours, minutes and seconds. It preserves hours above 99 but its result is text, not a time serial. Keep the numeric seconds or A2/86400 for arithmetic. Negative and missing durations are rejected.

=IF(OR(NOT(ISNUMBER(A2)),A2<0),"Invalid inputs",LET(s, ROUND(A2, 0), h, INT(s / 3600), m, INT(MOD(s, 3600) / 60), sec, MOD(s, 60), IF(h < 10, "0" & h, "" & h) & ":" & RIGHT("00" & m, 2) & ":" & RIGHT("00" & sec, 2)))

Convert seconds to Excel fractional day or decimal minutes

Dividing A2 / 86400 gives Excel serial days; dividing A2 / 60 gives decimal minutes.

The minutes calculation retains decimal seconds until the final two-decimal rounding. The text formatter and decimal-minute result therefore use different display precision.

=IF(OR(NOT(ISNUMBER(A2)),A2<0),"Invalid inputs",ROUND(A2 / 60, 2))

Further reading

• Microsoft Support — MOD function