Summing times.

  • Thread starter Thread starter Mike Klick
  • Start date Start date
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
 
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
 
Back
Top