Summary

The INTERVAL function formats a total number of seconds as a readable interval string. In this workbook engine, it is used to turn raw elapsed seconds into a display such as hours, minutes, and seconds.

This makes it useful for uptime logs, race timing, support durations, machine runtimes, and other reports where the source data is stored as total seconds.

Syntax

=INTERVAL(seconds)

The function takes one argument: the total number of elapsed seconds you want to format.

Arguments

• seconds - The total number of seconds to convert into a readable interval.

Important Compatibility Note

INTERVAL is supported by the spreadsheet engine used in this project, but it is not a standard Microsoft Excel worksheet function. If you need a native Excel-style alternative, a common approach is to divide seconds by 86400 and format the result with a custom format such as [h]:mm:ss.

INTERVAL vs Native Time Formatting

These approaches solve similar display problems, but they are not the same.

The main difference is that INTERVAL is a display-oriented function. If you still need to do arithmetic, keep working with the raw seconds first and format only at the end.

Using INTERVAL

INTERVAL is easiest to think of as a final presentation step. First calculate or collect the total seconds, then pass that number into INTERVAL to make it readable for users.

That is especially helpful when durations go beyond 24 hours. In many spreadsheet time displays, long durations can become confusing unless you use a custom format carefully. INTERVAL gives you a direct interval string from the second count.

Because the result is text, it is best used for display columns, labels, dashboards, and exported summaries. If you want to add, subtract, or average durations, do that math on the numeric seconds before converting them.

Example 1 - Convert One Hour of Seconds

A clean starting example is converting 3600 seconds into a readable interval.

=INTERVAL(3600)

This is useful when the source system stores elapsed time as raw seconds but the report should show a time-style result.

Example 2 - Convert an Irregular Duration

INTERVAL also works well when the duration includes hours, minutes, and seconds.

=INTERVAL(3665)

This kind of input is common in logs, timers, and stopwatch-style reports where the duration is not a neat round number.

Example 3 - Format a Duration Longer Than One Day

Long elapsed times are a good use case for INTERVAL because they often need a cumulative display.

=INTERVAL(90000)

Since 90,000 seconds is more than 24 hours, this example is useful for uptime tracking, long-running jobs, or multi-day process durations.

Example 4 - Format the Result After Doing the Math

It is usually best to do all arithmetic first and then format the result.

=INTERVAL(3600+10)

This pattern is useful for penalty seconds, buffer adjustments, bonus time, or any report where the displayed duration comes from a calculation.

Conclusion Recap

• Summary: INTERVAL formats a second count as a readable interval string.
• Best use: Displaying elapsed time from raw seconds.
• Important detail: The result is text, so do arithmetic before formatting.
• Good for: Uptime logs, race timing, support durations, and machine runtimes.
• Compatibility note: It is supported by this project's spreadsheet engine, but it is not a standard Microsoft Excel worksheet function.
• Native Excel alternative: Divide by 86400 and use a format like [h]:mm:ss.