The time( function converts text into a number representing a time.
This function has one parameter:
time – the text that is to be converted into a time value.
The time( function converts text into a number representing a time. (Note: The seconds( function is a synonym for the time( function, and works exactly the same.) The function returns a number representing the time. The number is the number of seconds since midnight. For example, if the time parameter is 10:23 AM this function will return the number 37,380.
The time( function tries very hard to understand the time you give it. It will accept a time without colons, for example 425 pm instead of 4:25 pm. If there is no am or pm the time function will assume it is 24 hour time.
The time( function will also convert named times: noon, midnight, morning, afternoon, evening, and night. By default the function assumes that morning is 9:00 am, afternoon is 1:00 pm, evening is 6:00 pm, and night is 10:00 pm.
Here are some examples of times that this function understands:
4:13 PM 11:00 AM 2:30 18:45 230 4p midnight noon morning afternoon evening night nite
Note: If you want to enter a time that is beyond 24 hours (for example an elapsed time) then you must use separators between the hours, minutes and seconds, like this:
You can use any punctuation character you like as a separator, including spaces or periods, however, there must be only one separator character between each number.
Illegal time – This error appears if a valid time is not specified. For example two o’clock is not a format that this function understands.
|10.0||Updated||The time( and seconds( functions have been combined, now both work exactly the same.|