Here is my timesheet:

c6: 11:00 pm
c7: 12:00 am
c8: 7:00 am
c9: 3:00 pm
c10: (Actual hours worked)

If I use the formula: =IF(C6C7,C7+1-C6,C7-C6)*24
I can get the time for c6/c7, but what formula do I use to not only get the
hours from c6/c7, but also from c8/c9 - to get the total of 9 hours in c10?

Thanks, I appreciate any help.