RE: Adding Hours & Minutes

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Everything looks correct. What is your formula returning? Is it returning a
zero, or just some number that doesn't agree with what you think it should be?

Possible problems:
Are your formulas, for some reason, returning a text value thus causing SUM
to = 0?

What are the floating 5's in your example for?
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Tina" wrote:

I am adding a large column of hours and need a total for the end of the
month.

0:00
0:00 5
0:00
0:00
0:00
0:00
0:00
0:00 5
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
0:00
00:00
I have formulas in the cells above to calculate the number of hours when an
employee enters their time.

I can't get it to give me a correct value of the hours and minutes. This is
what my formula looks like: =SUM(E12:E37)

The cell is formatted to this: [hh]:mm

.

Relevant Pages

  • Re: Show only cells greater than zero
    ... > the information of cells greater than zero in another location, ... I've created a monthly expense report that contains approx. ... > allows the employee to report amounts associated with miscellaneous ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Hiding zero values
    ... Format those cells to allow 2 decimal places by default ... > where the employee can enter in hours worked for each day. ... > person in charge of time sheets doesn't want any zero values in the TOTALS ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Complex if
    ... all of the conditions are either empty, have text, or have the numerical value zero. ... it suggests that those cells that meet the conditions contain zero -- assuming that #2 and #3 return exactly zero. ... IF('Enroll I'!$K$2:$K$2921>0, Enroll I'!$L$2:$L$2921))))))) ...
    (microsoft.public.excel.worksheet.functions)
  • RE: Find same value in continuous Cells
    ... I double checked my cells. ... The first zero value in this sheet occurs at E81 ... Dim Lastrow As Integer 'Last Row of Printing Range ...
    (microsoft.public.excel.programming)
  • RE: carry down total
    ... Now how do I get it not to reset to total to zero but be able to carry it to ... cruchnin numbers ... "Joel" wrote: ... tow cells inside the ANDare cells that contain the TRUE ...
    (microsoft.public.excel.misc)