I have a formula that averages time differences (e.g. entrance time to exit
time) by converting the differences regular numbers, then into minutes. The
result is that my average displays in minutes.

I'd like to be able to convert the minutes back into a h:mm format but it's
not working correctly. For instance, I have an average of 73.09 minutes but
when I set the cell format to h:mm it comes back with 5:14 which is
mystifying. How do I get the average to display 1:13? If anyone's got the
answer, please share, and thanks much.

Hi!

Divide the result of your formula by 1440:

=formula(......)/1440

Format the cell as [h]:mm

Biff

"danhattan" wrote in message
...
I have a formula that averages time differences (e.g. entrance time to exit
time) by converting the differences regular numbers, then into minutes.
The
result is that my average displays in minutes.

I'd like to be able to convert the minutes back into a h:mm format but
it's
not working correctly. For instance, I have an average of 73.09 minutes
but
when I set the cell format to h:mm it comes back with 5:14 which is
mystifying. How do I get the average to display 1:13? If anyone's got the
answer, please share, and thanks much.