Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 12-23-2024, 02:37 PM
ArviLaanemets ArviLaanemets is offline Numerous Columns in a Spreadsheet Windows 8 Numerous Columns in a Spreadsheet Office 2016
Expert
 
Join Date: May 2017
Posts: 932
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default

For simplest app, you need a table like:
Date, Employee, StartTime, EndTime, EntryType

To register the worktime for any employee, you add for this employee a row for every entry type you are registering for employee on this date. Like:
01.12.2024 Employee1 08:00 11:30 worktime
01.12.2024 Employee1 11:30 12:00 lunchtime
01.12.2024 Employee1 12:00 16:30 worktime
The worktime for Employee1 at 01.12.2024 is calculated as sum of worktime entries. The lunchtime is not included into worktime.

You need a separate table, where you define all possible EntryTypes, like:
worktime, lunch breake, state holiday, annual leave, sick leave, etc. In this table, you also determine for every entry type, does it add to worktime calculation, and when yes, does it add as positive or negative value (and whatever other additional info you need)

Now you can create any number of report sheets, like daily, weekly, monthly or yearly reports. At top of report sheet, you select a period for report (using Data Validation list), and any other filter conditions in case there is a need for them, and below conditions the report table is calculated based on your data entry and entry types tables, according the conditions you set for this report.

NB! In case the worktime can start and end on different dates (over midnight), you have to enter start and end times as datetimes (like 01.12.2024 08:00)!

NB! In report sheets, you have to format the cells with worktime totals (which surely may be >24 hours) like "[h]:mm"!
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Numerous Columns in a Spreadsheet How to convert document columns to excel spreadsheet davidjm Word 2 06-04-2018 11:03 PM
Reduction of columns in spreadsheet H28Sailor Excel Programming 0 12-14-2016 11:11 AM
Update date once and have it appear in numerous locations Mattress14 PowerPoint 2 09-05-2016 03:30 PM
Numerous Columns in a Spreadsheet Macro to copy specific columns in Excel from another spreadsheet KD999 Excel Programming 1 07-20-2012 08:58 AM
CAUTION!! Sorting a spreadsheet with hidden columns will trash your data. psmaster@earthlink.net Excel 0 11-24-2009 11:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:06 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft