What am I doing wrong here?

  • Thread starter Thread starter Charles May
  • Start date Start date
C

Charles May

I have the following information in column C (C1:C11) it is the result of
subtracting start and stop times

5:09
5:09
1:30
1:30
1:34
4:04
3:26
3:26
1:15
5:43
2:52

When I do a Sum(C1:C11) it results in 11:38. If I hilight C1:C11 the sum in
the lower corner shows 35:38

I've re entered this on a new sheet and still come up with the same results.
I even just entered the numbers above in cells and still get the same
result.

The sheet in general has column A with the start times and column B with the
end times and column C contains =B1-A1 to get the result. I've never had
this happen before. I actually went back through last weeks time card and
entered the information and it produced the results accurately.

I re-checked C12 and it does indeed read =SUM(C1:C11)

What am I not seeing???

Charlie
 
The current format is [hh]:mm
Which even if it wasn't it still wouldn't explain the difference in the SUM
result and the result it summarizes from hilighting the values (in the lower
right corner of the window).

I just feel like I'm over-looking something obvious.
Charlie

Dave Peterson said:
Give it a nicer numberformat:

[hh]:mm:ss
or
[hh]:mm



Charles said:
I have the following information in column C (C1:C11) it is the result of
subtracting start and stop times

5:09
5:09
1:30
1:30
1:34
4:04
3:26
3:26
1:15
5:43
2:52

When I do a Sum(C1:C11) it results in 11:38. If I hilight C1:C11 the sum
in
the lower corner shows 35:38

I've re entered this on a new sheet and still come up with the same
results.
I even just entered the numbers above in cells and still get the same
result.

The sheet in general has column A with the start times and column B with
the
end times and column C contains =B1-A1 to get the result. I've never had
this happen before. I actually went back through last weeks time card and
entered the information and it produced the results accurately.

I re-checked C12 and it does indeed read =SUM(C1:C11)

What am I not seeing???

Charlie
Click to expand...
Click to expand...
 
Are you saying you have the cell with the =SUM(C1:C11) formula formatted as
[hh]:mm (note the square brackets around the hh part) and it is not
displaying 35:38? Offhand, I don't see how that is possible. The answer to
your question other question is that without the square brackets, hours roll
over at the 24 hour mark... the SUM shown in the Status Bar obviously is
adding what it sees without using the 24-hour roll over point.

--
Rick (MVP - Excel)


Charles May said:
The current format is [hh]:mm
Which even if it wasn't it still wouldn't explain the difference in the
SUM result and the result it summarizes from hilighting the values (in the
lower right corner of the window).

I just feel like I'm over-looking something obvious.
Charlie

Dave Peterson said:
Give it a nicer numberformat:

[hh]:mm:ss
or
[hh]:mm



Charles said:
I have the following information in column C (C1:C11) it is the result
of
subtracting start and stop times

5:09
5:09
1:30
1:30
1:34
4:04
3:26
3:26
1:15
5:43
2:52

When I do a Sum(C1:C11) it results in 11:38. If I hilight C1:C11 the sum
in
the lower corner shows 35:38

I've re entered this on a new sheet and still come up with the same
results.
I even just entered the numbers above in cells and still get the same
result.

The sheet in general has column A with the start times and column B with
the
end times and column C contains =B1-A1 to get the result. I've never had
this happen before. I actually went back through last weeks time card
and
entered the information and it produced the results accurately.

I re-checked C12 and it does indeed read =SUM(C1:C11)

What am I not seeing???

Charlie
Click to expand...
Click to expand...
Click to expand...
 
Rick,
Sorry about that. I went back and looked and had set the format for the
results (C1:C11) to [hh]:mm but I did not format the C12 cell to [hh]:mm it
was set to h:mm so once I changed it, the correct results were displayed.

Thanks for your help

Charlie
Rick Rothstein said:
Are you saying you have the cell with the =SUM(C1:C11) formula formatted
as [hh]:mm (note the square brackets around the hh part) and it is not
displaying 35:38? Offhand, I don't see how that is possible. The answer to
your question other question is that without the square brackets, hours
roll over at the 24 hour mark... the SUM shown in the Status Bar obviously
is adding what it sees without using the 24-hour roll over point.

--
Rick (MVP - Excel)


Charles May said:
The current format is [hh]:mm
Which even if it wasn't it still wouldn't explain the difference in the
SUM result and the result it summarizes from hilighting the values (in
the lower right corner of the window).

I just feel like I'm over-looking something obvious.
Charlie

Dave Peterson said:
Give it a nicer numberformat:

[hh]:mm:ss
or
[hh]:mm



Charles May wrote:

I have the following information in column C (C1:C11) it is the result
of
subtracting start and stop times

5:09
5:09
1:30
1:30
1:34
4:04
3:26
3:26
1:15
5:43
2:52

When I do a Sum(C1:C11) it results in 11:38. If I hilight C1:C11 the
sum in
the lower corner shows 35:38

I've re entered this on a new sheet and still come up with the same
results.
I even just entered the numbers above in cells and still get the same
result.

The sheet in general has column A with the start times and column B
with the
end times and column C contains =B1-A1 to get the result. I've never
had
this happen before. I actually went back through last weeks time card
and
entered the information and it produced the results accurately.

I re-checked C12 and it does indeed read =SUM(C1:C11)

What am I not seeing???

Charlie
Click to expand...
Click to expand...
Click to expand...
 
Back
Top