View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RussPotts RussPotts is offline
external usenet poster
 
Posts: 1
Default 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