Calculating Time

Hey Guys,

New member but i've been using your threads to solve problems for months...so Thanks!

I have a bit of a quandry and haven't been able to find any solutions so i'd appreciate the help!

I have a schedule that looks like this (except with many more people and many more weeks). I'm looking for the formula that will count hours worked and display the total in another box.

Sunday Monday Tuesday Wednesday Thursday Friday Saturday Total
JANUARY 5 6 7 8 9 10 11
Eric OFF 13:00-21:00 7:00-19:00 7:00-15:00 7:00-15:00 8:00-16:00 OFF Formula? (that will display "44")

Let me know if you need any other details,

Thanks again,

Eric

Dear Friend

Find the attached sheet hope this will help you

Regards,

Attachment 178521