Making a time (15 Minute) interval exclusive

[gottabarra]

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?

I have attached my spreadsheet for a better understanding.

Thanks!FINALEnergyCalc.xlsx

[AndyLitch]

If you start at 00:00:00 and increment your times by =1/86400 *60*15

[gottabarra]

Sorry, I don't quite understand when I would enter that into?

[AndyLitch]

Sorry

If you put 00:00:00 at the top of your time interval data column (Say A1)

Then put = A1 + (1/86400 *60*15) in A2 and paste it down... That will generate a column of 15 minute time intervals

[VKS]

Sorry noticed that attachment is already available