Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |