Summing times.

M

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
 
R

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
 
Top