TIMEVALUE

Formulas / TIMEVALUE
Convert a text string into a time.
==TIMEVALUE(time_text)
  • time_text - a string that represents a time period

Examples

  • =TIMEVALUE("2:24 AM")

    The TIMEVALUE function takes a text string representing a time and returns its equivalent decimal value. For example, this returns 0.10, which is the decimal part of a day based on the time specified. This is because the day is divided into 24 hours, and each hour is further divided into 60 minutes, so 2:24 AM is equivalent to 2.4 hours or 0.10 of a day.

  • =TIMEVALUE("22-Aug-2011 6:35 AM")

    The TIMEVALUE function can also take a text string containing both a date and a time and return its equivalent decimal value. For example, this returns 0.2743. This is because the date specified is August 22nd, 2011 and the time is 6:35 AM. This is equivalent to 6.58 hours or 0.2743 of a day.


Summary

The TIMEVALUE function converts a text string representing a time to a decimal number between 0 and 0.99988426, which corresponds to times from 0:00:00 to 23:59:59.

  • The TIMEVALUE function takes a text argument specifying a time, and converts it into a proper Sourcetable time. The argument should be a date or time in a Sourcetable text format, and any dates present in the text string will be ignored.
  • A numeric time is more useful than text because it can be formatted as a time.

Frequently Asked Questions

What is the TIMEVALUE function?
The TIMEVALUE function is a formula in Sourcetable that returns the number of seconds represented by a text string.
What does the TIMEVALUE function take as an argument?
The TIMEVALUE function takes a text string as its argument. The text string represents a time.
What time formats are accepted by the TIMEVALUE function?
The TIMEVALUE function accepts any of the Sourcetable time formats.
Does the TIMEVALUE function take the date into account?
No, the TIMEVALUE function ignores date information in the text string.
What does the TIMEVALUE function return?
The TIMEVALUE function returns a decimal number. The decimal number is a value that ranges from 0 to 0.99988426.
What time does the TIMEVALUE function represent?
The TIMEVALUE function represents the times from 0:00:00 to 23:59:59.

Related Functions

Sourcetable Logo

Work smarter

Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.

Drop CSV