Forum Discussion
Average shift start
Hello everyone! I would like to see which worker starts how late and how early he finishes the job. I want to see their average! The start and stop columns have elapsed in minutes. Could someone h...
Hello,
the start and stop columns are in minutes. Start is delay from work(6:00+start minutes) and stop is earlier completion of work. I want to get the average of the delays. Unfortunately, multiple start and stop times are possible per shift. I want to get the lowest value at the beginning and the highest value at the end and average them monthly. how would this be possible? Thx
So, still not sure I understand but "lowest value at beginning" would be MIN([Start) and "highest value at end would be MAX([Stop])
???