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:
HTML Code: 
How can I modify it?

I have attached my spreadsheet for a better understanding.

Thanks!FINALEnergyCalc.xlsx