I am trying to create a sheet that can convert shift times into hours worked but will also recognise text values. Been playing around with the IF function and can get it to do one or the other but not both together. The two formulas I have are
=IF('Shift Times'!C6<=0,"",(TEXT(RIGHT('Shift Times'!C6,4),"00\:00")-TEXT(LEFT('Shift Times'!C6,4),"00\:00"))*24-0.5) AND IF('Shift Times'!C6="Sick","Sick"))
Is there a way of combining these two formulas so that they work together? Any help is appreciated.