How do you summarize time series data in Excel?

Hi all,I have been given a rather large output file that I'd like help with summarizing. The file lists when an employee has clocked in and out of the building. I'd like to be able

How do you summarize time series data in Excel?

Hi all,

I have been given a rather large output file that I'd like help with summarizing. The file lists when an employee has clocked in and out of the building. I'd like to be able to summarize time actually spent in the building per day, per week, etc. The formatting of the file is a little awkward as there are skipped rows, and the entry/exit descriptions are specific to the specific doorway scanned.

Could someone help me with this? I have very limited experience with pivot tables. Would that be appropriate here? If so, does anyone have suggestions for how to handle the formatting to make the file more conducive to a pivot table? I am working with Excel 2016.

Video liên quan