Changing hour and minutes to percentage of hours

R

RussPotts

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
 
F

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sum work hours to hours & nearest 10th of an hour 14
Hours and sum of hours 2
Formula to convert Hours to Days, Hours Minutes 1
turning "1 day, 1 hour, 30 minutes" into 1530 minutes 1
hours converted to Days hours and minutes 1
Calculate Hours and Minutes in Report.... 1
Another Days, Hours, Minutes, Question 6
Changing decimal numbers to hours and minutes 1

Top