View Single Post
Old 04-03-2017, 06:15 PM
clantb clantb is offline
Aspiring Member
Join Date: Mar 2017
Posts: 1
clantb has 10 reputation points
Default CMS aux reports to Excel - issue with formatting time

I have a bunch of aux reports I want to put into Excel and be able to run a pivot table to find out how often people are over on lunch and break and stuff of that nature. However, I can't get excel to sum up the time. It works ok for hours but not for minutes.

I can do a bunch of formulas in Excel to format the data ok but I was hoping not to have to do that.

Anyone here doing this and maybe have a better method?
Reply With Quote