Thread: Sum Times
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Sum Times

[h]:mm will return 30:00. If you get very strange amounts then you probably
have something else than 10:00 in your cell(s). 34:00 perhaps ? <g

HTH. Best wishes Harald


"Frank" skrev i melding
...
I am trying to Sum times...

10:00
10:00
10:00


The programing I have used is =SUMIF(B1:B31,"0")

It seems to work, however when the Sum comes up it shows 6:00
Not 30:00.
I have been working with the formating of the time cells as well, but get
very strange amounts when I change hh:mm to [h]:mm.

Can someone please help.

Thanks