When it came to tracking and reporting employee work time, the City of Stillwater, OK, wasn’t radically different from a lot of city governments out there today. Though, to hear Lavicky talk about it, that wasn’t necessarily a bragging point…
“Our work week runs from Thursday midnight through Wednesday midnight,” explains Lavicky, Stillwater’s Vice President of Information Technology. “So, on Thursday morning, when payroll has to be turned in, it used to be a madhouse trying to get employees to sign their timesheet, trying to find the supervisors to sign off on their timesheets, trying to get everything arranged alphabetically for payroll and getting it down there by the deadline.”
The root cause of this weekly madhouse was a mixed system of antiquated time clocks (and the required accessories: paper cards, ribbons, etc.) and Microsoft Excel spreadsheets. All of which required huge amounts of manual operation to enter, track, and report work hours for roughly 500 city employees operating out of city hall and ten remote locations. …
