Summing times.

[Mike Klick]

I know this should be easy, but it doesn't seem to work:

Cell formatted in Custom h:mm. I use =SUM(L3:74) with L75 same h:mm format.
It seems to skip or miss some.

What am I doing wrong.

Mike

 

[RagDyer]

Change your custom format to:
[h]:mm

The square brackets prevents the hours from rolling over to days.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

I know this should be easy, but it doesn't seem to work:

Cell formatted in Custom h:mm. I use =SUM(L3:74) with L75 same h:mm format.
It seems to skip or miss some.

What am I doing wrong.

Mike

 

[Mike Klick]

That did it!

Thanks,

Mike