If, Time, Text, Blank Cell [Closed]

Registration date
Friday October 5, 2018
Last seen
October 5, 2018

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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!