Read cell formated as Time

[Larry]

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

 

[Larry]

Turns out the FORMAT function works. Didn't think it would handle it, but it
does.

Hi Larry,
To convert the Excel time to hours, multiply by 24.

More information on Date and Time on these two sites
the first is mine, and more sites in the #related area
http://www.mvps.org/dmcritchie/excel/datetime.htm
the second is Chip Pearson's
http://www.cpearson.com/excel/datetime.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

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