Hi
Is that formula not incorrect. If I input 17.25 in A1 and format cells mm:ss it returns 17:25 instead of 17:15.
Quote:
Originally Posted by macropod
I know that's what you're assuming.
If the assumption is wrong, the OP needs something like:
=(INT(A1)+MOD(A1,1)/0.6)/1440
where the decimal time is in A1.
|