Is there a way to read a time value from a cell in the same format it is displayed in?
I have cells formatted as mm:ss.00.
When I read the cell value via macro it returns the time serial number.
I've tried formatting this serial number in VBA as follows Format(A1, "hh:mm:ss.00") before outputting it.
Unfortunately it always returns the time without the decimal places on the seconds component
So 02:07.35 is returned as 02:07.00 and 03:05.87 is returned as 03:06.00.
Any ideas?
Bookmarks