Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 in advance Hassan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
solution wants | Excel Discussion (Misc queries) | |||
VBA solution required? | Excel Programming | |||
odd vlookup solution required - can you rise to the challenge?! | Excel Programming | |||
Is There A Solution.......? | Excel Programming | |||
Solution Required to prevent #Ref! when rows deleted | Excel Worksheet Functions |