Time Calculations

[TIM]

Hi All,____Wonder if you can help, we have a requirement to work out how long a vehicle was idle during the day, in other words the ignition is turned on but the speed is 0.____In the database we have a time stamp (updated every 30 seconds), a speed, and a logical ignition on or off. ____Can R & R make this calculation if so how or do we need to bug a programmer?____Have a nice weekend ____Regards____Tim ____

[kfleming]

R&R has a number of functions that would allow you to perform such a calculation.____Kathleen__R&R Support

[happydermis]

Hi Tim,____This doesn^t sound that difficult.____The compunents you need from the DB are:__1. all DB lines from a certain vehicle on a certain day (...give me all lines where vehicle no.1425 apears on date YYYY/MM/DD).__2. from this amount of information you need only the DB lines (also called Tuples) where the vehicle was turned on but the speed indicator was showing 0.__3. when you have filtered those lines you are now looking at a certain vehicle on a certain day but only those events where the vhicle wasn^t moving but the motor was on are presented.__4. than you have to sum all these lines together and you get the idle time of that vehicle.____which DB do you use?____greetings, Dekers