Timeclock

[Clan]

Hey

I'm working on a time registrationform for my company.
We can export the data to excel but I want to make it easier to look stuff up.
I've tried doing it but am stuck on an issue.

Basically everyone badges in and out. The form calculates the total amount of hours someone badged in and out.
What I can't seem to solve is an error message if someone forgets to badge in or out. because this will mess up the entire form resulting in everyone else's time not being accurate.

Everything should be even (in & out) but not badging results in an uneven number of data.
Ideally I want to make a difference between working hours and breaks.

I've attached the form I made so far to this post.

Maybe someone can help me out or point me in the right direction? That would be appreciated!

[Pepe Le Mokko]

What are you actually trying to achieve?