convert time in decimals to minutes
a) =TIME(INT(A1)+(MOD(A1,1)0.6),(MOD(A1,1)+IF(MOD(A1 ,1)0.6,-0.6,0))*100,0)
b) just use AVERAGE
--
HTH
Bob
(there's no email, no snail mail, but somewhere should be gmail in my addy)
"joaniemic" wrote in message
...
I'm trying to
(a) convert time shown in decimals to time in minutes. Example, I would
like
3.75 to become 4:15 (4 minutes 15 seconds).
(b) I then take an average of 5 or six of the above numbers.
Thank you.
|