colon as an operator (used twice in a string)
Greetings - why does Excel automatically interpret 1:53:822 (1 min 53.822
secs) as 0.087986111, yet 1:53:022 is not changed at all? Is there a way I
can calculate backwards the 0.0879... result into the original 1:53:822?
(These are times I am copying/pasting from a website into a spreadsheet.
There are dozens of them, and I'd rather not rekey them).
I spent a couple hours messing around with time/date formatting, reverse
engineering the calculation, etc., and have not cracked the code. And I can't
find anything out about the colon as an operator that would indicate what is
going on.
Any thoughts??? Thanks for any help! And happy holidays!!
-Tom
|