Formula
 

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

Formula
 

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.

"Hassan" wrote:

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