Difference between revisions of "Manuals/calci/TIMEVALUE"

From ZCubes Wiki
Jump to navigation Jump to search
 
(5 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=TIMEVALUE(SomeString)=
+
<div style="font-size:30px">'''TIMEVALUE (String)'''</div><br/>
 +
*where <math>String</math> is a text string that represents time
 +
**TIMEVALUE() converts a time in the form of text to a serial number.
  
*where <math>SomeString</math> is a text string that represents time
 
 
TIMEVALUE() returns the decimal representation of time entered by a text string.
 
  
 
== Description ==
 
== Description ==
  
TIMEVALUE(SomeString)
+
TIMEVALUE(String)
  
 
For Example,
 
For Example,
Line 13: Line 12:
 
TIMEVALUE("7:00 PM") returns ''0.7916666666642413''
 
TIMEVALUE("7:00 PM") returns ''0.7916666666642413''
  
*Argument <math>SomeString</math> can be the time in a time format, considering a 24 hour clock from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 PM).
+
*Argument <math>String</math> can be the time in a time format, considering a 24 hour clock from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 PM).
*<math>SomeString</math> should be enclosed in quotation marks (e.g. "12:00 PM" or "20:30").
+
*<math>String</math> should be enclosed in quotation marks (e.g. "12:00 PM" or "20:30").
 
*The decimal output of time value is in the range from '0' to '0.999988426'. e.g. 12:00 PM is half of a day, represented as '0.5'.  
 
*The decimal output of time value is in the range from '0' to '0.999988426'. e.g. 12:00 PM is half of a day, represented as '0.5'.  
*If <math>SomeString</math> is entered in day time format, date value is ignored. e.g. In "4-FEB-2010 4:00 PM", date value is ignored.  
+
*If <math>String</math> is entered in day time format, date value is ignored. e.g. In "4-FEB-2010 4:00 PM", date value is ignored.  
 
*If any arguments are invalid, Calci returns an #ERROR message.
 
*If any arguments are invalid, Calci returns an #ERROR message.
  
Line 44: Line 43:
 
| class="sshl_f" |0.625
 
| class="sshl_f" |0.625
 
|}
 
|}
 +
 +
*TIMEVALUE("next day")  = 0.49999999999272404
  
 
==Related Videos==
 
==Related Videos==
  
{{#ev:youtube|7kpLxH7WjKg|280|center|TIMEVALUE}}
+
{{#ev:youtube|v=yvyXnw7awEU|280|center|TIMEVALUE}}
  
 
== See Also ==
 
== See Also ==
Line 60: Line 61:
 
*[http://en.wikipedia.org/wiki/Time Time]
 
*[http://en.wikipedia.org/wiki/Time Time]
 
*[http://en.wikipedia.org/wiki/Decimal_time#Scientific_decimal_time Scientific Decimal Time]
 
*[http://en.wikipedia.org/wiki/Decimal_time#Scientific_decimal_time Scientific Decimal Time]
 +
 +
 +
 +
*[[Z_API_Functions | List of Main Z Functions]]
 +
 +
*[[ Z3 |  Z3 home ]]

Latest revision as of 05:50, 27 May 2022

TIMEVALUE (String)


  • where is a text string that represents time
    • TIMEVALUE() converts a time in the form of text to a serial number.


Description

TIMEVALUE(String)

For Example,

TIMEVALUE("7:00 PM") returns 0.7916666666642413

  • Argument can be the time in a time format, considering a 24 hour clock from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 PM).
  • should be enclosed in quotation marks (e.g. "12:00 PM" or "20:30").
  • The decimal output of time value is in the range from '0' to '0.999988426'. e.g. 12:00 PM is half of a day, represented as '0.5'.
  • If is entered in day time format, date value is ignored. e.g. In "4-FEB-2010 4:00 PM", date value is ignored.
  • If any arguments are invalid, Calci returns an #ERROR message.

Examples

Function Output
TIMEVALUE("4:30:30 AM") 0.18784722222335404
TIMEVALUE("15:00") 0.625
TIMEVALUE("10:00 PM") 0.9166666666642413
TIMEVALUE("10-DEC-2000 15:00") 0.625
  • TIMEVALUE("next day") = 0.49999999999272404

Related Videos

TIMEVALUE

See Also

References