How to calculate total hours

[Annie30]

Hello,

I made a Pivot Table in Excel to know how many hours the company spends
at a client. The table shows me all the hours spent, and it gives me a
total per client.

Unfortunately, Excel reads time as 24 hours. And i would like to know
how the format my cells so it calculates the total of time.

For exemple :

What it does

Client name Duration Sum Total Duration
xxx 05:30
04:30
04:30
04:30
04:00
03:00
02:00

I want the total to be 26:00


Thanks

Annie
Québec, Mtl

 

[Andy B]

Annie

Format the answer as [hh] and this will ignore the fact that there are 24
hours in a day!!

Andy.