Returns the time as a decimal given a time in text format.
|time_text||The text string that represents the time.|
|* In Excel times are represented as decimals.|
* If "time_text" contains any date information, it is ignored.
* If "time_text" is not a valid time, then #VALUE! is returned.
* 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).
* The time format can be any of those on the "Format Cells" dialog box.
* You can use the DAY function to return the day as an integer given a date serial number.
* You can use the DATEVALUE function to return the date serial number for a date in text format.
* You can use the MINUTE function to return the minute as an integer given a date serial number.
* You can use the SECOND function to return the number of seconds as an integer given a date serial number.
* You can use the TEXT function to convert a date serial number into a formatted text string.
* For the Microsoft documentation refer to support.office.com
© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top