If, Time, Text, Blank Cell [Closed]

Report
Posts
1
Registration date
Friday October 5, 2018
Status
Member
Last seen
October 5, 2018
-
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!