if, time, text, blank cell

Hi, 

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 

=IF(E3>=D3,E3-D3,24-D3+E3) 

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 

=IF(AND(LEN(D7),E7>0),E7-D7,D7) 

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 *