Excel: Converting Time Entered as a Number to a Valid TimeLast reviewed: November 30, 1994Article ID: Q78933 |
The information in this article applies to:
SUMMARYThe formula shown below converts time entered, without the colon (:) (for example, 121010 instead of 12:10:10), to a valid serial number so that time calculations can be performed or number formatting applied.
MORE INFORMATION
Example
The value, 0.410543981, which is a valid serial number, should result in cell A2. Now, cell A2 should display the value 9:51:11.
REFERENCES"Microsoft Excel Function Reference," version 3.0, pages 137-138, 151-152, 200, 243
|
KBCategory: kbusage
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |