calculate average hours and minutes

G

Guest

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!
 
G

Guest

Hours and minutes in this format: 7:43, 8:09, 9:43, 6:21, 5:53 now I have to
average these hours and minutes for a weekly average and then a YTD
average......
 
P

Peo Sjoblom

Just use AVERAGE and format as [hh]:mm

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
G

Guest

That helped me Thank You!

Peo Sjoblom said:
Just use AVERAGE and format as [hh]:mm

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



llstephens said:
Hours and minutes in this format: 7:43, 8:09, 9:43, 6:21, 5:53 now I have
to
average these hours and minutes for a weekly average and then a YTD
average......
Click to expand...
Click to expand...
 

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

calculate average hours worked 1
sum hours and minutes with Excel 2000 9
Calculate average in intervals 1
mixed text and formula results 2
Average for times using minutes and seconds 2
How do I enter accumulated time as hours, minutes and seconds? 1
Function to calculate total hours worked in one week. 4
Calculate Average and dispaly in another worksheet 2

Top