FORMATTIME ^v2.6.131

Converts an Excel date/time serial number to a string in the format 'HH:mm:ss'.

FORMATTIME(time_value)

Parameters

• time_value - The Excel date/time serial number to format.

Examples

FORMATTIME(44444.5)

Result: 12:00:00

FORMATTIME("2023-04-18 13:45:00")

Result: 13:45:00