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
|