How to use excel TIMEVALUE function

Introduction

TIMEVALUE function in Excel is a type of TIMEVALUE/TIME function. This function is used to change time which is in form of text to a valid excel format and gives result in form of serial number in the Excel time system. For example, formula =TIMEVALUE(“11:02 AM”) gives 0.459722 as the result.

 Syntax

=TIMEVALUE(Time_Text)

Arguments

  • Time_Text-  It is the text or cell reference which represents the time value in valid excel format.

Keynotes

  • In General formatting of Excel, TIMEVALUE function gives you result in form of a serial number, to get it in a readable form you have to apply the number format function.
  • Any data info. present in the argument will be ignored.
  • The TIMEVALUE function is also used with COUNTIFS and SUMIFS functions which add a dynamic nature to these functions and they update automatically when TIMEVALUE value is changed.

Examples

Here we have added hour, minute, second in respective columns A, B, C and used the TIMEVALUE function to enter Serial number in Excel Format in column E.

Leave a Comment