FORMATTIME ^v2.6.131
Converts an Excel date/time serial number to a string in the format 'HH:mm:ss'.
js
FORMATTIME(time_value)
FORMATTIME(time_value)
Parameters
time_value
- The Excel date/time serial number to format.
Examples
js
FORMATTIME(44444.5)
FORMATTIME(44444.5)
Result: 12:00:00
js
FORMATTIME("2023-04-18 13:45:00")
FORMATTIME("2023-04-18 13:45:00")
Result: 13:45:00