Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|