View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Karl Karl is offline
external usenet poster
 
Posts: 114
Default I am trying to calulate total time

I am working on a spreadshett to calulate my total hours worked. How can I
add this together? I have tried to just add the time with the SUM feature, I
have tried to add each item individually...However, the program is adding
these like they are actually times during the day and not total hours worked
each day. I am trying to find the total hours worked in the HH:MM format...I
should get a total somewhere around 30:52 but I am getting 6:57 as an answer.
How do I fix this?