S
shannon
Hi,
In a pivottable, I've no problem to group Date fields i.e,
days, mths and quarters. However, when I'm trying to
group Time fields (seconds, minutes, hours), the "starting
at" is always showing "1/1/1900". How do I group the Time
fields with specified time intervals e.g, intervals of
5mins or etc.
Thank you and regards.
In a pivottable, I've no problem to group Date fields i.e,
days, mths and quarters. However, when I'm trying to
group Time fields (seconds, minutes, hours), the "starting
at" is always showing "1/1/1900". How do I group the Time
fields with specified time intervals e.g, intervals of
5mins or etc.
Thank you and regards.