My numbers dont add up, help

By 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??

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Check the following link....

by Darryl~ Moderator In reply to My numbers dont add up, h ...
Collapse -

You want to stick with [h]:mm

by seanferd In reply to My numbers dont add up, h ...

This is exactly the only thing I use Excel for.

Collapse -

Another Method

by BlueBlood1978 In reply to My numbers dont add up, h ...

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.

Related Discussions

Related Forums