Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Date and Time > TIMEVALUE
 

TIMEVALUE(time_text)

 
 Returns the time as a decimal returned as text given a date serial number.

 time_textThe text string that represents a time in any one of the Microsoft Excel time formats.

 REMARKS
 
  		• Any date information that is included in the "time_text" argument is ignored.
     
  		• The decimal number is a value ranging from 0 (zero) to 0.99999999, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).
     
  		• Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5 because it is half of a day).
     
  		• To view the number as a time, select the cell and click Cells on the Format menu. Click the Number tab, and then click Time in the Category box.

     EXAMPLES
     
     A
    1=TIMEVALUE("2:24 AM") = 2:24 AM
    2=TIMEVALUE("22-Aug-1955 6:35 AM") = 6:35 AM
    3=TIMEVALUE("01/07/1977 12:00:00") = 12:00 PM
    4=TIMEVALUE(TEXT(0.12345,"hh:mm:ss")) = 2:57 AM
    5=TIMEVALUE(TEXT(0.12345,"dd-mm-yy hh:mm:ss")) = #VALUE!
    6=TIMEVALUE(TEXT(0.12345,"0.000")) = #VALUE!
    		 
     Functions - T | Index - T | Dates & Times | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top