convert time in decimals to minutes

[joaniemic]

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.

 

[Bob Phillips]

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)

 

[Rick Rothstein \(MVP - VB\)]

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