Hi,

I have the below formula in cell R8 which calculates the total hours worked based on abbreviations of the type of shift and the standard hours the specified shifts cover. The problem I now have is that where shifts are split between employees to cover sickness there is a need to indicate the actual times each employee is working that day (see k8). Is it possible to add onto the formula below to count additional hours worked (D8:Q8) if the hours in those cells that require it were in time format i.e. 09:00 - 13:00.

Any help would be much appreciated.

=SUM(COUNTIF(D8:Q8, {"D","N","DC","B/D"}))*12.25+COUNTIF(D8:Q8,"TWL")*12

I have the below formula in cell R8 which calculates the total hours worked based on abbreviations of the type of shift and the standard hours the specified shifts cover. The problem I now have is that where shifts are split between employees to cover sickness there is a need to indicate the actual times each employee is working that day (see k8). Is it possible to add onto the formula below to count additional hours worked (D8:Q8) if the hours in those cells that require it were in time format i.e. 09:00 - 13:00.

Any help would be much appreciated.

=SUM(COUNTIF(D8:Q8, {"D","N","DC","B/D"}))*12.25+COUNTIF(D8:Q8,"TWL")*12

Last edited by a moderator: