Рет қаралды 11,795
💥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)
~