How To Use Timevalue Function In Excel | How to calculate the hour using two given time values

Excel TIMEVALUE Function

The Excel TIMEVALUE function converts a time represented as text into a proper Excel time.
For example, the formula =TIMEVALUE("9:00 AM") returns 0.375,
which is the numeric representation of 9:00 AM in Excels time system.
the Numeric time values are more useful than text since they can be directly manipulated
with formulas and pivot tables.

the Purpose of this function is to Get a valid time from a text string
and Returns a value that has A valid Excel time as a decimal number

Syntax
=TIMEVALUE (time_text)
Arguments
time_text - A date and/or time in a text format recognized by Excel.

Examples
The formulas below show the output from TIMEVALUE:

=TIMEVALUE("12:00") // returns 0.5
=TIMEVALUE("12:00 PM") // returns 0.5
=TIMEVALUE("18:00") // returns 0.75

You can follow us on the below social media handles:-