Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Read cell formated as Time
I have a friend that is trying to read an Excel spreadsheet, where one
column is formatted as TIME. It shows fine in the column (3:00) but when he tries to read it (external to Excel) he gets the value .125. I told him it's stored as a fraction of 24 hours, but he wants to get the "3:00" value (of course) and not the .125 value. I could not figure it out, off the top of my head, so I thought I'd post to see if there was a quick response to this. In the mean time, I'll keep searching. Thanks, Larry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add 24 hours to a date and time value formated cell? | Excel Discussion (Misc queries) | |||
Cell formated as text changes when copied | Excel Discussion (Misc queries) | |||
Adding zero's to Time formated cell | Excel Worksheet Functions | |||
Adding numbers to a Time Formated cell | Excel Discussion (Misc queries) | |||
Paste a formated Cell with protection can it be done | Excel Discussion (Misc queries) |