How to make an employee time tracker with Excel [Easy setup]
Вставка
- Опубліковано 27 чер 2024
- 💥Check out Connecteam 👉 connecteam.cc/3QSAjlQ
~
Recently I needed to make a timesheet solution for my clients. I used Excel 365 with forms to create a quick & elegant application. It works on phones, web browsers and PC. You can track shift information and consolidate the data at the end of month for payroll processing.
In this video, let me present you with the solution and approach I took.
For an easier and error proof solution, do check out the sponsor of this video Connecteam here - connecteam.cc/3QSAjlQ
~
Timestamps for the video:
=====================
0:00 - Demo of my time tracking app
1:06 - Creating the app using Excel on web
1:52 - Setting up the data entry form
3:45 - Adding "Branching Logic" to show different options based on the data entered.
4:32 - Saving and publishing the form (app)
5:30 - Testing our app
8:12 - The problem with our solution
8:45 - A better time tracking solution (with Connecteam)
~ - Наука та технологія
💥Check out Connecteam 👉 connecteam.cc/3QSAjlQ
Thanks for sharing. I learn a lot from your posts about Excel. Excellent work. Incidentally, how would you build an app to track employee leave dates in excel but making sure that there are no overlaps in a range of dates for more than two persons in the same job category from the same department or section?
You are welcome. I suggest using a proper HR solution for stuff like this as Excel tends to be a bit hard to keep track of such things. Connecteam offers built-in features for such things.
Alternatively, you can also use Excel formulas to validate date range overlaps and signal a warning on the screen.
Yes, great idea
Excellent, thanks Chandoo!
Glad you liked it!
Interesting and very useful... more videos like this please
Very neat! Thanks
"Revolutionary time tracking solution! This Excel-based app for managing employee shifts and timesheets is a game-changer. A must-see for anyone looking to streamline workforce management. Dive in to simplify and optimize your scheduling process!"
Have you ever competed in any of the Excel Championships i.e. Microsoft Excel Championship ?
Not my cup of tea...
Could you teach us how to use forward lookup to do the calculation on total hours clocked by an employee? just curious.
Sure... here is the logic. It assumes the data is the table and you are adding a column inside the table to get the next matching recording for the employee in current row.
=IF([@[What do you want to do?]]="Start a custom shift", XLOOKUP(1, ([Email]=[@Email])*([What do you want to do?]="End previous custom shift")*([Completion time]>[@[Completion time]]),[Completion time],"Did not end the shift",-1),"")
I can not find the form icon
1st