I need to calculate hours to be worked in one cell. This spreadsheet will
caluclate the hours scheduled for the week, then add them up and mulitply by
payrate:

1 Mon(2) tue(3) wed(4)
thurs(5) total hours
A Employee {8am-1pm) (9am-3pm) (5:30pm-11pm) ???

the question mark marks where i need the formula