![]() |
Changing hour and minutes to percentage of hours
I am making a time card for work. I have formated it so that it came out in
hours and minutes. My work wants the totals to be in percentages of an hour. ie: 4hrs 30 minutes should be shown as 4.5 hours. Could someone please tell me how to change the format? Thanks Russ |
Changing hour and minutes to percentage of hours
hi
a quick way would be to multiply your 4 hr 30 min by 24(hours in a day) then format as general. Regards FSt1 "RussPotts" wrote: I am making a time card for work. I have formated it so that it came out in hours and minutes. My work wants the totals to be in percentages of an hour. ie: 4hrs 30 minutes should be shown as 4.5 hours. Could someone please tell me how to change the format? Thanks Russ |
All times are GMT +1. The time now is 12:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com