convert minutes to hours in pivot table...

[raj_20]

Could anybody help me out with this...
I have created this pivot table in ms access 2007 out of the data available. These are averages of minutes (time) for every month out of the total minutes for that month. Now i want to convert this minutes into hh:mm (hours:minutes)format inorder to get a better analysis.. how do i go about?
Thanks...

[CJ_London]

Assuming you can have more than 24 hours returned (1440 minutes) you can't actually use a date format to get the hours but will need to use a formula

assuming 121.5028902 is minutes would be

format(minutes\60,"00") & ":" & format(minutes mod 60,"00")

which will give you 02:02

which rounds the minutes

if you are always below the 24 hr limit then you can use

format(minutes/(60*24),"hh:nn")

which does not round minutes

[raj_20]

Tnks Ajax for your valuable reply...
but the format code you have provided can be utilised in Query.. How do i do it in Pivot table?
From the attached image you could examine that only the count field is highlighted and can be used whereas i cannot use the average function...
Please tell me how to go about it now...

[CJ_London]

regret I've not used pivot tables to any great extent but think you will need to do something slightly different to what I original suggested

1. create your calculated 'min' value as minutes/(60*24)

2. then in the pivot table view, right click on the min column heading and select properties. In the format tab - number put hh:nn or perhaps hh:mm

This will only work for values less that 1440

[raj_20]

Thanks Ajax.. for the solution
I could manage to do it the way i want.. but still its a big data-sheet, i would let you know if i am having any difficulties...

thanks once again..