Elapsed Time Format

The custom number format [h]:mm, where the square brackets mean total elapsed hours that do not wrap at 24. With an ordinary h:mm a total of 39:01 would show as 15:01.

When to use

Use it whenever a time total can exceed 24 hours, such as weekly or monthly hours or a project duration. For pay calculations multiply by 24 to get decimal hours instead.

See Lec 05.

Appears in

No references yet.