T
thomas
Hi !
I need to make a chart for statistics of machines.
Table:
MachineID: 43
Starttime: dd.mm.yy hh:nn
Endtime: dd.mm.yy hh:nn
What I need is a query which tells me for each machine how many hours a
day have been worked and how many not.
Looks easy but isnt.
The intervall between start and end can be from hours to several days.
24h a day => 18h worked, 6 h not working
Thanks Thomas
I need to make a chart for statistics of machines.
Table:
MachineID: 43
Starttime: dd.mm.yy hh:nn
Endtime: dd.mm.yy hh:nn
What I need is a query which tells me for each machine how many hours a
day have been worked and how many not.
Looks easy but isnt.
The intervall between start and end can be from hours to several days.
24h a day => 18h worked, 6 h not working
Thanks Thomas