# Time Sheet Calculator

1. ## Time Sheet Calculator

Sheet.jpg

I have attached a picture for you guys.
I am accountant in a small business.
As you can see in the image I have double Arrival & Exit timing.
I have double it because if an employee goes out for any kind of personal work he will write exit time on his sheet if he returns on the same day he will write arrival timing and when his duty duration is finished he will write exit.
Now let's get on point I wanted to use such kind of formula that I would be able to just write timings, and the late minutes column & overtime column will show the late minutes and over time minutes by formula.
If any employee is late more than 15 minutes his timing will be written in late minutes column.
Usually total employee working minutes in my company is 540 min per day if he gives more than 540 minuter in my company it will be considered overtime.
Kindly help me if you can.
I am little weak in VBA but if you would help me I would be able do something or it could be done without vba.
Tell me about the format if you understand it or not.

2. ## Re: Time Sheet Calculator

try this it should do what you need

I've uploaded an example, however it will not let me place example formula's in this text area for some reason

So I have placed copies on example sheet

3. ## Re: Time Sheet Calculator

here is a VBA Solution (A Guru on here wrote the original code) I take no credit for this

``Please Login or Register  to view this content.``

4. ## Re: Time Sheet Calculator

Thanks.
Can I use any kind of formula for late minutes.
If a employee reaches office at 9:15 he will not be considered late but if he reaches office at 9:16 he will be considered late.
And the late minutes column will show 16 min late.

5. ## Re: Time Sheet Calculator

if more than 15 minute late the the text in the late cell turns red and underlined.

Non VBA Revised

VBA Example Revised

6. ## Re: Time Sheet Calculator

Thanks Mr.Toonies
You helped me a lot.

7. ## Re: Time Sheet Calculator

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