Convert time in cell
Assuming your time is in cell A1 a formula like this should do...
=MINUTE(A1)+SECOND(A1)/60
--
HTH...
Jim Thomlinson
"John" wrote:
I am looking for help in how to convert the following:
16:06 (16 minuts and 6 seconds) to minutes (16.1 minutes)
Cell currently reads 16:06
How do I change so cell reads 16.1?
--
John
|