Converting to h:mm from regular number
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. |
Converting to h:mm from regular number
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. |
All times are GMT +1. The time now is 02:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com