Hi all,
I am making a pivot table that I am splitting up time intervals into 15 minute integers. I am having trouble making the value the is input into the pivot table exclusive to the 15 minute interval.
Eg. 0:00 - 1:00 = 1 Hour
which is; 0:00-0:15, 0:15-0:30, 0:30-0:45, 0:45-1:00... however the formulae I am using is inclusive of 1:00-1:15 as from 0:00 - 1:00 includes 1:00.
I am using this equation:How can I modify it?HTML Code:
I have attached my spreadsheet for a better understanding.
Thanks!FINALEnergyCalc.xlsx
Bookmarks