Add time values.

  • Thread starter Thread starter Mike Klick
  • Start date Start date
M

Mike Klick

I have a columnn of h:mm - time values. If I do SUM(A1:A50) it does not add
correctly. What am I doing wrong.

Mike
 
Two possibilities (among others):

1) If your times add to more than 24:00, you need to format your result
with Format/Cells/Number/Custom

[h]:mm

to keep XL from "rolling" over the time.

2) If your times are text, SUM() will ignore them. Copy a blank cell,
select your times, and choose Edit/Paste Special, selecting the Values
and Add radio buttons. This will coerce text into numbers.
 
Back
Top