I've been trying to figuer this formula all week and I just dont know how he got it to work. Is there anyone that can give me a explanation how to get this formula by using the fx function in excel and step by step of what array in formula does: =SUM(SUBSTITUTE(TEXT(C3:H3,"0.00"),".",":")*{-1,1,-1,1,-1,1})*24
Employee Time Sheet.xls | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | |||
2 | Start Time | Lunch Start | Lunch End | Break Start | Break End | End Time | Total | |||
3 | Employee | 5.30 | 8.32 | 9.02 | 10.00 | 10.20 | 14.00 | 7.67 | ||
Sheet1 |