I've got some data from our shop floor program that shows transaction/clocking dates...but i need to find the total dwell time at each operation.
The data looks like this:
Machine #1: 12/1/15
Machine #1: 12/2/15
Machine #1: 12/8/15
Machine #2: 12/8/15
Machine #2: 12/10/15
Since i'm pulling multiple reports, i'm looking for a faster way of getting this info pulled, as opposed to looking at the first/last date of each operation
any ideas how i can manipulate this info?
Bookmarks