LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
llstephens
 
Posts: n/a
Default calculate average hours and minutes

I am given average hours per day worked and I have to give an average hours
and minutes per week and a YTD weekly average. I can't seem to get excel to
calculate the numbers in hours and minutes format and everytime I try to
format the number to time, it puts an am or pm on it so it still won't come
out with the right answer. Please Help!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
CALCULATE HOURS WORKED Calculation of hours worked. Excel Discussion (Misc queries) 3 January 20th 05 06:01 PM
Formatting Hours and Minutes Anthony Slater Excel Discussion (Misc queries) 2 January 20th 05 02:03 PM
How do I convert times from hours to minutes? kkrebs Excel Discussion (Misc queries) 5 December 30th 04 06:13 PM
adding hours and minutes Tricia New Users to Excel 2 November 27th 04 12:29 AM
calculate average hours worked llstephens Excel Worksheet Functions 1 November 24th 04 02:37 PM


All times are GMT +1. The time now is 09:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"