View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
ability ability is offline
external usenet poster
 
Posts: 1
Default Adding Up Time Calcs

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?