G
Guest
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.
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.