deepcalc
DocsTIMEVALUE

TIMEVALUE

View as markdown/docs/functions/timevalue.md Ask Claude about this pageOpens Claude with this page's address

Converts time text to serial number.

  • Excel: Not checked yet
  • Google Sheets: Not checked yet
  • Returns: Number (time serial)

Examples

=TIMEVALUE("14:30:00")
Result 0.6041666666666666

Syntax

TIMEVALUE(time_text)
time_text
text required

Errors

#VALUE!
=TIMEVALUE("alpha")
DATECreates date from year, month, day. DATEDIFCalculates difference between two dates. DATEVALUEConverts date text to serial number. DAYReturns day of month from date. DAYSReturns number of days between two dates. DAYS360Returns days between dates on 360-day year.