Problems with date

[#1]

Hi sorry for my bad english

i have a field that is numeric... i had to transform this to a time mode.

for example the number 65 is 1 hour and 5 minutes. So the pivot table msut show 1h 5min.

And also it has to make the SUM of all the times,,

is this posible ?? thanks.

[#2]

Hi,

see the attached example for more help.

Good luck!

Rainer

[#3]

this ok...

but another thing ..

inthe filed of the chart Proyect duration (days hours etc) how can it makes the sum

[#4 · Accepted solution]

This is not possible here. The reason is it´s a alphanumeric field and not a number.

Rainer

[#5]

Thanks.