Hello All. I have a sheet of automatically pulled counters that updates every 15 minutes. What I want to do is figure out the difference for each shift in the counters for each day for fixed date ranges. For example in the attached sample there are 5 machines listed. For the first machine (Don) I want to calculate the difference for column F between 7:15 AM and 3:15 PM for any number of days. The columns I am interested in is always the last column for each machine so F, K,P,W,AD. I have been able to do this with the following formulas for each machine for the current day but have no idea how to add up several days. The three formulas below calculate the meters on the machine Don for the end of the current shift NOW() to NOW()-.3334 and so on.
Any direction you can give would be great. The shift I have are 7:15 AM to 3:15 PM, 3:15 PM to 11:15 PM and 11:15 PM to 7:15 AM. Currently I run this report at the end of each shift which allows me to use NOW() as the starting point.
RealTimeSample.xlsx
LinkBack URL
About LinkBacks
Please Login or Register to view this content.
Register To Reply
Bookmarks