Formualizer Docs
ReferenceFunctionsDate & Time Functions

TIMEVALUE

TIMEVALUE: Parses a time string and returns its fractional-day serial value.

Summary

Parses a time string and returns its fractional-day serial value.

Remarks

  • Supported formats include 24-hour and AM/PM text forms with optional seconds.
  • Result is a fraction in the range 0.0..1.0 and does not include a date component.
  • Because only a time fraction is returned, workbook date-system choice does not affect output.

Examples

Parse 24-hour time
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.6041666667
Parse 12-hour AM/PM time
Grid
CellValue
No inputs on Sheet1.
Formula
=
Result
Not evaluated yet.
Expected
0.6041666667

FAQ

Does TIMEVALUE depend on the 1900 vs 1904 date system?

No. TIMEVALUE returns only a time fraction, so date-system selection does not change the result.

Runtime metadata

Category

Date & Time

Signature

TIMEVALUE(arg1: Any)

Arity

min 1, max 1

Arguments

arg1

Any · Scalar

Caps

PURE

Source

crates/formualizer-eval/src/builtins/datetime/date_value.rs

TIME

Returns the fractional-day serial for a time built from hour, minute, and second.

TODAY

TODAY: Returns the current date as a volatile serial value.

On this page

SummaryRemarksExamplesRelated functionsFAQDoes TIMEVALUE depend on the 1900 vs 1904 date system?Runtime metadata