View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wet Nose Wet Nose is offline
external usenet poster
 
Posts: 1
Default Adding hours scheduled for week

I have created a work schedule with start/end time cells formated hh;mm
AM/PM. The "total hours scheduled" cell is formated [h]:mm. I need a
formula for the "total" cell that will add the weekly shifts. Ex; Monday
10-5 + Tuesday 12-8 etc. equals 15:00 I've tried to SUM (time out-time in)
and it will work for one day, but I can't figure out how to add the remaining
work days - all it get is errors. Please help!