Description
The CTime function converts Numbers, Strings, DateTime, and HH, MM, SS values to Time values.
Arguments
Returns a Time value given a number in units of 24 hours. Number can be fractional or negative as well.
Returns a Time value that represents the time, given a String expression specifying a time from 0:00:00 (12:00:00 A.M.) to 23:59:59 (11:59:59 P.M.), inclusive.
DateTime is a DateTime value.
HH is a whole number representing an hour of the day; MM is a whole number representing a minute; SS is a whole number representing a second.
Action
CTime (number) converts the given number to a Time value; the given number is in units of 24 hours, can be fractional or negative as well.
CTime (string) converts and returns a time given a string that identifies a Time value.
CTime (dateTime) converts and returns a time given a DateTime value.
CTime (hh, mm, ss) converts and returns a time given the arguments of the hour, minute and seconds.
Examples
CTime (.2)
CTime (1.2)
Both return the same value 4:48:00 a.m.
CTime (-.2)
Returns 7:12:00 pm
CTime ("Jan. 6, 1999 2:30pm")
Returns 2:30:00 pm
CTime (#Feb. 24, 1999 2:40pm#)
Returns 2:40:00 pm
CTime (18, 30, 30)
Returns 6:30:30 pm
Comments
You can use the IsTime function to check if a String argument can be converted to a Time before doing the actual conversion. That way, if the conversion cannot be done, you can handle the situation appropriately.