Problems with Formulas to calculate hours worked

**Declan McMonagle** · 05-01-2013, 03:27 PM

Hi All,

I'm Trying to compile a spread sheet to simplify tracking our employees working times. Ideally I would like to only enter the Daily Start Time for each employee, Time Taken for Break, and then the Daily Finish times and allow the work sheet calculate the Total Hours worked each day less their break time, the amount of time of time worked after (the basic 10 hours) overtime worked each day and have these calculated per employee at the end of the 7 Day week.

Currently I can get enter the start, break, and finish times and this will calculate fine, but the issue is if working less than the 10 hours I get ####. This is the same when there are no working hours entered for eg. Saturday and Sunday, all I get is #### for the overtime cell, and also it calculates 10.00 even though no start/break/finish times have been entered.

I am also looking for the total number of basic working hours worked and the number of overtime hours worked totalled in the last 2 columns.

Any help with this would be much appreciated. Sorry if I haven't explained it correctly, I have only very basic knowledge of Excel.

**ChemistB** · 05-01-2013, 03:59 PM

Hi Declan and welcome to the board. A few things;
1. You didn't exactly say what the problem is with your spreadsheet, what is it doing right and what is it doing wrong?
2. Edit your first post with a more appropriate title describing the problem briefly so that others can use the title to help themselves as described in the rules (an example might be "Timesheet not properly calculating totals")
http://www.excelforum.com/forum-rule...rum-rules.html
3. It's hard to fix a spreadsheet from a picture. Upload an example without any confidential information and you'll get better responses with more accurate info. (Go Advanced>Manage Attachments)

1. Edit your first post with a more suitable

**zbor** · 05-01-2013, 04:22 PM

As ChemistB said.
Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

**ChemistB** · 05-02-2013, 08:36 AM

Okay, Excel doesn't like negative times so you need to watch for them.
FYI, in H2
=SUM(G4-G3-G2) just needs to be = G4-G3-G2, Excel doesn't require the "SUM"

In H3, I'd do
=IF(H2> 0.41666667, H2- 0.4166667, 0)
Does that help?