Good afternoon,

I have to create pivot tables and graphs and the time format is
screwing up on it.

For example, 22/02/2005 07:00:06 in the pivot table turns into
22/01/2005 07:00 when I create the graph from it (using F11 as
directed). I've set the "great minds" here at work in PC Support on it
and the best workaround they can come up with is to remove the first
colon in the time, which makes the seconds appear - 22/02/2005 0700:06.
While this does give the seconds, it looks a bit wafty and I'd rather
have a permanent solution via formatting or something.

Any help greatly appreciated.

Ta.