Adding Up Time Calcs

A

ability

I am building a spreadsheet to add up hours worked per day and cumulative
hours worked per week. I can get the hours per day subtotal fine but get
wierd numbers for the cummulative hours per week.

All cells are formatted as hLmm and the Total for the Week cell has the
formula of =SUM(B22:H22) but the anser I am getting comes no where near the
actual sum of those cells.

Can you solve this?
 
J

joel

Your results are being truncated to a number less than 24 hours. To display
hour greater than 24 hours you need to use the time format under Custom
Format that has a square bracket around the hours [h].
 
J

Jacob Skaria

In the total cell right click. Format Cells-->Select Custom and enter [h]:mm


If this post helps click Yes
 

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