Sheet formulas now understand times written as text
TIMEVALUE("14:30:45"), and HOUR, MINUTE and SECOND on a typed time, return the right value instead of a #VALUE! error, with both 24-hour and AM/PM times.
Fix · Create ·
TIMEVALUE("14:30:45"), and HOUR, MINUTE and SECOND on a typed time, return the right value instead of a #VALUE! error, with both 24-hour and AM/PM times.
October 2026 · Releases & improvements
Designs Mo builds from a brief now show an Open button in the chat · Links in Mo's answers now take you there on your phone