Formula

[Hassan]

Hi All,

I have a full movement report of a vehicle and I have to check the status of
movement, following are the statuses

If vehicle Movmed from 05:30 to 13:30 then Its "1st Trip"
if vehicle moved from 13:30 to 21:30 then its "2nd Trip"
if vehicle moved from 21:30 to 05:30 then its "Private"
if vehicle moved before 05:30 to after 05:30 then its "Private / 1st"
if vehicle start before 13:30 and off after 13:30 then its "1st / 2nd"
if vehicle start before 21:30 and off after 21:30 then its "2nd / Private"

Thanks & Regards

Hassan

 

[Sean Timmons]

So, is the understanding that you have two columns, move start and move end?

If so, you may want to have two answer columns. First evaluates first
field, second evaluates second field.

=if(AND(A2>=(5.5/24),A2<=(13.5/24)),"1st
Trip",if(AND(A2>(13.5/24),A2<=21.5/24)),"2nd Trip","Private"))

copy and paste to the rigth to get 2nd column results.

Then, in a 3rd formula column, you can just use =C2&"/"&D2 to show 1st/1st,
1st/2nd, etc.