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.
if(condition){ do firstthing; }else{ if(othercondition){do secondthing; }else{ do thirdthing; } }
. You can use the same logic on Excel functions. – Seth May 31 '17 at 11:39C6
suggesting there is only a single value. How is this shift timeS – Dave May 31 '17 at 14:29