Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 75
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"