Hi folks,
Im trying to make query to tell me how many hours and minutes it is between two startuptimes.
I have a machine that starts and stops which is recorded on a table. Each cycle counts as autonumber.
I have a startup time and a stop time recorded as HH:MM.
Anyone knows how to calculate the time it goes between startuptime @ cycle 1 and startuptime @ cycle 2 ?
These cycles occour on diffrent dates. Hope there is a way to get this to work
EDIT:
Basically what i want to know is much time it goes between each Startup of the machine.
Thanks,
ps, sorry for my bad english.
Best regards,
Doria