Time Sheet Calculator

[ShujaatShahid]

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.

[Toonies]

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

[Toonies]

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.

[ShujaatShahid]

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.

[Toonies]

I have added your requirements to your sheets.

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

Non VBA Revised

VBA Example Revised

[ShujaatShahid]

Thanks Mr.Toonies
You helped me a lot.

[Toonies]

Glad I could help, don't forget to mark thread as solved