How to calculate total hours

  • Thread starter Thread starter Annie30
  • Start date Start date
A

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
 
Annie

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

Andy.
 
Back
Top