software

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

quot;danhattanquot; gt; wrote in message
...
gt;I have a formula that averages time differences (e.g. entrance time to exit
gt; time) by converting the differences regular numbers, then into minutes.
gt; The
gt; result is that my average displays in minutes.
gt;
gt; I'd like to be able to convert the minutes back into a h:mm format but
gt; it's
gt; not working correctly. For instance, I have an average of 73.09 minutes
gt; but
gt; when I set the cell format to h:mm it comes back with 5:14 which is
gt; mystifying. How do I get the average to display 1:13? If anyone's got the
gt; answer, please share, and thanks much.