Interval

[uwmarkyo]

Hi can I know how to add a fixed 24 hour interval into my existing pivot table?

The ideal interval looks like below:
Interval
12:00:00 AM
12:30:00 AM
1:00:00 AM
1:30:00 AM
2:00:00 AM
2:30:00 AM
3:00:00 AM
3:30:00 AM
4:00:00 AM
4:30:00 AM
5:00:00 AM
5:30:00 AM
6:00:00 AM
6:30:00 AM
7:00:00 AM
7:30:00 AM
8:00:00 AM
8:30:00 AM
9:00:00 AM
9:30:00 AM
10:00:00 AM
10:30:00 AM
11:00:00 AM
11:30:00 AM
12:00:00 PM
12:30:00 PM
1:00:00 PM
1:30:00 PM
2:00:00 PM
2:30:00 PM
3:00:00 PM
3:30:00 PM
4:00:00 PM
4:30:00 PM
5:00:00 PM
5:30:00 PM
6:00:00 PM
6:30:00 PM
7:00:00 PM
7:30:00 PM
8:00:00 PM
8:30:00 PM
9:00:00 PM
9:30:00 PM
10:00:00 PM
10:30:00 PM
11:00:00 PM
11:30:00 PM
12:00:00 AM


Currently my interval is like this: How can I make data automatically sort into my fix interval?

Thanks, please teach me.

 

[jasonb75]

Currently my interval is like this: How can I make data automatically sort into my fix interval?

Are you saying that you want the missing intervals included in the pivot table? If that is the case then you would need to add data for those intervals to the data source.
A pivot table will only show results based on the data that is present in the source, not that which is absent.

 

[uwmarkyo]

Are you saying that you want the missing intervals included in the pivot table? If that is the case then you would need to add data for those intervals to the data source.
A pivot table will only show results based on the data that is present in the source, not that which is absent.

Thanks for a quick respond.
can I merge 2 data sources (one is interval, one is data table) to create a fix interval table?
I actually tried it, but it still only would show the one is data source only.

any solution for this?

 

[jasonb75]

Check post 5 in this thread, see if following the instructions there gives you what you want.

Show columns in pivot table, even if they are empty - Excel 2007

I want to be able to have a standard set of lookup formulas in a worksheet that reference specific columns in a pivot table. However, when I refresh the pivot table with updated data, some of the columns go out of view because they have no data in them. I'd like those columns to show in my pivot...

www.mrexcel.com