Questions

My numbers dont add up, help

Tags:
+
0 Votes
Locked

My numbers dont add up, help

carlosmlr
i have made a schedule in excel:
time in time out total hours worked
4:00 PM 10:00 PM 6:0
when this is entered for each day, then i made a formula to total the hours for the week, ok some problems here because when formatting i had to use different items so it would add up correctly, ie sometimes h:mm and sometimes [h]:mm, but now i am trying to add up all the hours using =SUM(X6:X26) and it wont add up??
  • +
    1 Votes
    seanferd

    This is exactly the only thing I use Excel for.

    +
    0 Votes
    BlueBlood1978

    There is another method of doing what you are asking. The method calls for unused "white space" either at the far right or at the bottom of the time sheet. You would use the formula to find the number of hours between time in located in column A and time out located in column B, in Column C you would have the formula set up for the finding out of the hours, then using Conditional Formating to hide the result. For the end of the week, you would use =Sum(c1:c7) (or where ever the column of hidden information is) and it will show the number of hours worked for the week.

    +
    1 Votes
    seanferd

    This is exactly the only thing I use Excel for.

    +
    0 Votes
    BlueBlood1978

    There is another method of doing what you are asking. The method calls for unused "white space" either at the far right or at the bottom of the time sheet. You would use the formula to find the number of hours between time in located in column A and time out located in column B, in Column C you would have the formula set up for the finding out of the hours, then using Conditional Formating to hide the result. For the end of the week, you would use =Sum(c1:c7) (or where ever the column of hidden information is) and it will show the number of hours worked for the week.

  • +
    1 Votes
    seanferd

    This is exactly the only thing I use Excel for.

    +
    0 Votes
    BlueBlood1978

    There is another method of doing what you are asking. The method calls for unused "white space" either at the far right or at the bottom of the time sheet. You would use the formula to find the number of hours between time in located in column A and time out located in column B, in Column C you would have the formula set up for the finding out of the hours, then using Conditional Formating to hide the result. For the end of the week, you would use =Sum(c1:c7) (or where ever the column of hidden information is) and it will show the number of hours worked for the week.

    +
    1 Votes
    seanferd

    This is exactly the only thing I use Excel for.

    +
    0 Votes
    BlueBlood1978

    There is another method of doing what you are asking. The method calls for unused "white space" either at the far right or at the bottom of the time sheet. You would use the formula to find the number of hours between time in located in column A and time out located in column B, in Column C you would have the formula set up for the finding out of the hours, then using Conditional Formating to hide the result. For the end of the week, you would use =Sum(c1:c7) (or where ever the column of hidden information is) and it will show the number of hours worked for the week.