PC Review


Reply
Thread Tools Rate Thread

Changing hour and minutes to percentage of hours

 
 
RussPotts
Guest
Posts: n/a
 
      23rd Nov 2008
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
 
Reply With Quote
 
 
 
 
FSt1
Guest
Posts: n/a
 
      23rd Nov 2008
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

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:38 PM.