Formatting times greather than 24 hours

[Anonymous]

Hello,

I made a pivot table containing times formatted as Hour (h.mm.ss).

In the total row, when the value is grather than 24 hours, it shows only the "total hours MOD 24" (e.g. 20h + 20h = 16h) and not the complete total (1day and 16 h or, better, 40h!).

I tried to change the format in (D hh.mm.ss) but it rapresents in every cell the original time preceded by a 30 value!!.

Can anybody help me?

Thank you very much.

[Miguel_Angel_Baeyens]

Hello,

Try the interval function

=Interval(time('20:00') + time('20:00'))

Hope that helps

[Anonymous]

Sorry, maybe I didn't explain very well the problem.

In the pivot table the data of the duration time is catch directy by the database and shown in the pivot table cells, and the totals (with the problem I explained before) are automatic (with the check-box "Show subtotal" in the Graphical tag), so I can't follow your suggestion.

Example of the table:

User Duration

-----------------------

John 10:00:00

Mike 15:00:00

Andy 20:00:00

-----------------------

Total 21:00:00 (instead of 1 21:00:00 or better 45:00:00)

[Miguel_Angel_Baeyens · Accepted solution]

Hi,

You may need to format Duration as interval in the Numbers tab. I've tried with the following and it works, showing "47:00:00", using Sum(B) as expression.

LOAD * INLINE [A, B1, 11:00:002, 13:00:003, 23:00:00];

[Anonymous]

That's great!!

Thank you very much for your help.