TIMEVALUE function

Excel TIMEVALUE Function is a built-in function that allows you to convert a time string into a decimal number, making it easier to work with time values in your spreadsheets.

Syntax

TIMEVALUE(time_text)

Arguments

time_textThe time text you want to convert into a decimal time value.

How to use

You can use the TIMEVALUE function to convert a time string into a decimal number. Here’s how you can do it:

This formula will return 0.4375, which represents 10 hours and 30 minutes in decimal form.

You can also use this function to convert time values in cells. For example, if cell A1 contains the text “2:45 PM,” you can use the formula:

This formula will return 0.614583333, which represents 2 hours and 45 minutes in decimal form.

It’s important to note that the TIMEVALUE function assumes the time text is in a valid time format. If the text is not a recognized time, you’ll get an error.

Examples

Here are some examples of how to use the TIMEVALUE function:

This formula returns 0.34375, representing 8 hours and 15 minutes.

This formula returns 0.645833333, representing 3 hours and 30 minutes.

This formula returns 0, as it represents midnight (0 hours and 0 minutes).

These examples demonstrate how you can use the TIMEVALUE function to convert time text into decimal time values, making it easier to perform calculations and work with time in your Excel spreadsheets.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.