If anyone can help me with this it would be greatly appreciated. I am using the following formula to determine if an employee has worked their required hours for the month to show "Nil", if they have worked less than one extra day (7hrs) "Hours", or if they have worked more than an extra 7 hours "Days". It is working fine except that I have one person that has worked their exact hours but it shows "Days" instead of Nil. I figure this is because it is set up in custom hours [h]:mm but I can't work out how to correct this. Have tried entering 0:00 in my formula.
=IF(c28=0,"Nil",IF(C28>7,"Days",IF(C28<7,"Hours")))
Thanks in advance.
=IF(c28=0,"Nil",IF(C28>7,"Days",IF(C28<7,"Hours")))
Thanks in advance.