convert time in decimals to minutes
 

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.

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.

convert time in decimals to minutes
 

Maybe I am missing something in the OP's question, but isn't your first
formula returning a value of hours:minutes rather than the number 4:15 as
minutes:seconds?

Wouldn't this...

=TIME(0,INT(A1),100*MOD(A1,1))

with a Custom Format of m:ss be more in line what the OP would want?

Rick


"Bob Phillips" wrote in message
...
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.