? Sum(hh:mm)

[Morten]

Hi.

I am searching for a way to sum a column formatted like .NumberFormat =
"hh:mm".

These values represent used time.

Now I want to sum the entire column and of course get total used time but
can't get passed 24 h!



As long as the total time not exceeds 23:59 my values are correct, but how
do I get d.hh.mm???



If nessecary I can do this whith vba.



Hope for a quick answere!





Morten

 

[Morten]

Thank!

..NumberFormat = "[hh]:mm" also seems to work.