Welcome to Mr Excel forum

Maybe this...

ABCDEFGH1 Day 1 Day 2 Day 3 Day 4 Day 5 Day 6 Day 7 Total Hours2 10:15-18:30 10:15-14:30 off off 10:30-18:30 9:30-16:30 9:00-4:00 46,5

Array formulain H2

=SUM(IF(IFERROR(TIMEVALUE(LEFT(A2:G2,SEARCH("-",A2:G2)-1)),0)>IFERROR(TIMEVALUE(RIGHT(A2:G2,LEN(A2:G2)-SEARCH("-",A2:G2))),0),IFERROR(TIMEVALUE(RIGHT(A2:G2,LEN(A2:G2)-SEARCH("-",A2:G2))),0)+1,IFERROR(TIMEVALUE(RIGHT(A2:G2,LEN(A2:G2)-SEARCH("-",A2:G2))),0))-IFERROR(TIMEVALUE(LEFT(A2:G2,SEARCH("-",A2:G2)-1)),0))*24

confirmed withCtrl+Shift+Enter, not just Enter

Hope this helps

M.

## Like this thread? Share it with others