Forum Discussion
lmelton
Jun 16, 2020Copper Contributor
Creating an Exact Calendar Lookup Table
I'm creating a pivot table that summarizes energy usage recorded at a site vs. what the billing company says was actually used at the site. I've ran into trouble having both sets of data display,...
SergeiBaklan
Jun 16, 2020Diamond Contributor
I'd round minutes in calendar using
=MROUND(A2+TIME(0,15,0),"00:15")
Second, in the bill table some date show next date, not sure why
If simply re-enter it'll be as in formula bar. With changing the date on Apr 01 PivotTable is