Ask Your Question

Revision history [back]

You may use TEXT(<ref>, "[HH]") to get the string with requested value. If you need a number, you may multiply your datetime value by 24, and have a float with whole part as number of hours, and fractional part as fraction of an hour (rationale: datetime is a floating-point value that represents time as number of days). Formatting the result as Number (opposed to Time) will give you result in convenient form.