# Creating an Employee Timesheet with Excel

1. ## Creating an Employee Timesheet with Excel

I'm creating an Employee Timesheet and running into problems with the formulas. I was able to get the Date & Day to populate when the Pay period start date is entered but the hours don't add up properly. We don't have sick pay or vacation pay but there are special bonus pay hours (for instance you're sent home early but told you will be paid for that time). I copied these formulas from support threads like this one so I may have gotten them wrong. I'd appreciate it if someone could take a look and see why my formulas don't add up please? I've spent days on this and I'm stuck! thank you so much!

2. ## Re: Creating an Employee Timesheet with Excel

Looks pretty good to me.

First, take the *24 out of all formulas in Column I. Time is a decimal.

Next, update =IF(SUM(I14:K14)=SUM(L14:L28),SUM(I14:K14),"Error!") to include the full range in the SUMs.

=IF(SUM(I14:K28)=SUM(L14:L28),SUM(I14:K28),"Error!")

Lastly, change the output format of L28. Choose L28, hit ctrl+1, and go to Custom. Use [h]:mm:ss. This will allow hours to overflow beyond 24.

Good to go.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1