Changing hour and minutes to percentage of hours

's Computer Specifications

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

's Computer Specifications

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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Converting hour/minutes to hours/hundredths	Tbazemore	Microsoft Excel Worksheet Functions	1	4th Jan 2010 08:36 PM
Changing from hours to minutes.	GEM	Microsoft Excel Discussion	2	16th Feb 2009 07:30 PM
How do I add hours and minutes without 24 hour limit	Cycling Steven	Microsoft Excel Worksheet Functions	1	25th Jan 2008 02:18 PM
How can I add hours and minutes then multiply by cost per hour?	=?Utf-8?B?VG9tIERpQmVsbA==?=	Microsoft Excel Worksheet Functions	1	8th May 2006 07:52 PM
subtract half an hour from hours and minutes	MajorGeneralDes	Microsoft Excel Misc	2	22nd Nov 2004 08:58 PM