Time Format

Also known as · Time Formats

A number format that changes how a time is displayed (h:mm, h:mm AM/PM, h:mm:ss and so on) without changing its value. Set it in Format Cells (Ctrl+1) with a Time category or a custom code.

When to use

The same cell value, 0.4065..., shows as 9:45 or 9:45:22 AM depending on the format. For totals that can pass 24 hours use Elapsed Time Format instead, or the display wraps.

See Lec 05.

Appears in

No references yet.