Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
TimeStamp Conversion
Hello,
I have a file that puts various time stamps in a column. Such as 173236 forand 93527. I want to know how you can display the numbers as the 24 hours. Like this (17:32:36) (09:35:27). Notice the orginal text outputs either 5 characters or 6 depending either if its before 12 pm or after 12 pm. But the final result after the conversion should be 6 characters, (with a leading zero if before 12 PM). Any thoughts? Thanks in advance, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
TimeStamp Conversion
=TIME(INT(M1/10000),INT(MOD(M1,10000)/100),MOD(M1,100))
-- HTH RP (remove nothere from the email address if mailing direct) "Denham" wrote in message ... Hello, I have a file that puts various time stamps in a column. Such as 173236 forand 93527. I want to know how you can display the numbers as the 24 hours. Like this (17:32:36) (09:35:27). Notice the orginal text outputs either 5 characters or 6 depending either if its before 12 pm or after 12 pm. But the final result after the conversion should be 6 characters, (with a leading zero if before 12 PM). Any thoughts? Thanks in advance, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Timestamp | Excel Discussion (Misc queries) | |||
Timestamp ? | Excel Discussion (Misc queries) | |||
Labview timestamp conversion | Excel Worksheet Functions | |||
Timestamp | Excel Discussion (Misc queries) | |||
timestamp on each row... | Excel Programming |