Creating a UTC-Based Employee Time Clock in Excel

In this Microsoft Excel tutorial, I'm going to show you how to create a Time Clock sheet for employees. You'll be able to click buttons to clock them in and out. More importantly, we'll store the date in Universal Time (UTC) to avoid any problems with daylight saving time clock changes in the middle of an employee's shift

David from Tallahassee, Florida (a Platinum Member) asks: You created a video a couple of years ago about Daylight Saving Time and implementing it in Microsoft Access. Well, my employer still has us using an Excel spreadsheet to track clocking in and clocking out. Is there any way to achieve the same functionality in Excel, perhaps by associating it with a button that employees can click to clock in and out?

Prerequisites

• Excel VBA: https://599cd.com/ExcelVBA

Links

• DST Code: https://599cd.com/DSTCode
• ISO Date Format: https://599cd.com/ISODatesX
• Daylight Saving Time in Access: https://599cd.com/UTC

Members

There is no extended cut, but here's my workbook file:

•  Workbook Download - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Recommended Courses

• Excel Beginner, Expert Courses: https://599cd.com/Excel
• Dropdown Lists in Excel Expert 10: https://599cd.com/XLX10

Want More Excel?

Most of what I do is Microsoft Access, so if if you want to see me post more Excel videos, make sure to comment below: "I want more Excel!"

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

excel 2021, excel 2016, excel 2019, excel 365, microsoft excel, ms excel, ms excel tutorial, #msexcel, #microsoftexcel, #help, #howto, #tutorial, #learn, #lesson, #training, #database, #techhelp, dst, daylight saving time, utc, timeclock, Time Clock sheet, employees, clock in, clock out, buttons, Universal Time, time tracking, employee shift, time clock changes, time management, time conversion, local time to UTC, UTC conversion, Excel functions, VBA, macro, automation, custom function, time zone conversion, daylight saving time adjustment, employee time tracking, Excel time clock