View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Calebs Grandma
 
Posts: n/a
Default =SUM(A1:A5)*24 for totalling hours and minutes is not working

I am trying to total up hours worked in a one week time period. I found the
noted formula if the total is going to be 24 hours. However, I cannot get
an accurate total. Any thoughts comments, would be greatly appreciated.