if, time, text, blank cell


I have multi shifts as under; 

6 to 14 = 8 
7 to 14 = 7 
14 to 22 =8 
22 to 06 = 8 
22 to 7 = 9 

I am using 


which one getting correct results with both time or decimal format, 

Now Problem is, it is not showing text gives error and if cells are blank then it displays 0 (Zero) 

I need 

if Cell A & B have time then calculate hours in C 
if cell A Or B have text then Text in C 
if cell A or B is blank then Blank C 

Someone suggest this 


but in this wheh i post 10 to 06 it gives error.

By: Kaleem

Leave a Reply

Your email address will not be published. Required fields are marked *