Excel excel and averaging hours worked


Joined
Nov 8, 2006
Messages
1
Reaction score
0
Hi, i've got a spreadsheet that i need to create, and i'm having a few problems getting the formulas correct.

I've got 18 columns for hours worked each week, i then need to calculate the average hours worked each week over the 18 weeks and present it as an hours and minutes format (of which i'm using the average formula), but my main problem is i need to present the result as hours and minutes worked, and so far i've only got it coming up in a 24 hour time format

can anyone help?

thanks
Leon.
 
Ad

Advertisements

Joined
Oct 25, 2005
Messages
28
Reaction score
0
Have you tried applying a custom format to the answer cell.

Right Click on cell, select format, select custom.

On the number tab under category select custom then under type enter h:mm for just hours & minutes

See attached jpg
 

Attachments

Ad

Advertisements

Joined
Nov 23, 2007
Messages
28
Reaction score
2
Alternativly if you have not yet found, go to >Format cells>Numbers>Custom, and either click on or create [h]:mm this will give you accumulated hours and 59minutes
ie: 12:25 +17:30+10:00=39:56 as opposed to 15:56 you are currently getting.
Chuck
 

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

Top