ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Changing hour and minutes to percentage of hours (https://www.excelbanter.com/excel-programming/420430-changing-hour-minutes-percentage-hours.html)

RussPotts

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

FSt1

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