Hello MVP's, Geeks, Newbies!!
I am an absolute 'DoDo' when it comes to Formulas, please help with the
following request: I have a spreadsheet with employees times (and 'OFF', 'H'
etc), see the example below of a typical Monday. Each shift is an 11 Hour
WORKING shift.
I would like to 'COUNT' all fields in each column that has a 'working time'
and then MULTIPLY the 'count' by 11. What would be the easiest formula to
use??

Mon
OFF
7-19
7-19
6-18
H
T
7-19
7-19
OFF
19-7
9-21
OFF
H

THANKS for your answers, best regards.