OT Tracking system for multiple employees

Mikelowrey

Board Regular
Joined
Apr 20, 2014
Messages
51
Office Version
  1. 2016
Platform
  1. Windows
Good morning,

I would like to create a 2 spreadsheets that would track the overtime on over 50 employees, Cells would constitute of

DATE LASTNAME FIRSTNAME TOUR WORKED AMOUNT OF TIME REASON SUPAPPROVAL LOG # for the OT in time and

DATE LASTNAME FIRSTNAME TOUR WORKED AMOUNT OF TIME CASH REASON SUPAPPROVAL LOG # for the OT in cash


Now, in this I would like to be able to pull weekly, monthly, 28 days, quarterly and yearly reports, now my REAL question is, is this feasible in excel or is it better in access? I have no knowledge of access but I guess I could try if is more easier.

Thank you in advance.
 

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Comfy

Well-known Member
Joined
Dec 21, 2009
Messages
3,386
It is feasible yes, but I would suggest keeping it to one sheet.

So you would have:


Excel 2010
ABCDEFGHI
3DateLastNameFirstNameTour WorkedAmount of TimeHourly RateReasonSupaApprovalLog #
Sheet1

There's no need to duplicate the info.
 

Mikelowrey

Board Regular
Joined
Apr 20, 2014
Messages
51
Office Version
  1. 2016
Platform
  1. Windows
It is feasible yes, but I would suggest keeping it to one sheet.

So you would have:

Excel 2010
ABCDEFGHI
3DateLastNameFirstNameTour WorkedAmount of TimeHourly RateReasonSupaApprovalLog #

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1


There's no need to duplicate the info.

Comfy,

Thanks for the quick reply, I was thinking the same, all that info in just one sheet, and then have others sheets run the numbers i guess?

I did state the ways I woul dlike to run the reports, plus the following: by individuals, earnings, hours worked, and like a Query type thing. is this possible again? thanks!
 

Comfy

Well-known Member
Joined
Dec 21, 2009
Messages
3,386
Yep, you can setup several Pivot Tables on different sheets to show what ever info you want.

Here are two very quick examples:

Source Data

Excel 2010
ABCDEFGHIJ
1DateLastNameFirstNameTour WorkedAmount of TimeHourly RateTotal PayReasonSupaApprovalLog #
201/01/2014AATour 127.515Staff ShortageT Wilkins1
302/01/2014BBTour 151050Staff ShortageT Wilkins2
403/01/2014CATour 137.522.5Staff ShortageT Wilkins3
504/01/2014DBTour 16530Staff ShortageT Wilkins4
605/01/2014AATour 147.530Staff ShortageT Wilkins5
706/01/2014BBTour 181080Staff ShortageT Wilkins6
807/01/2014CATour 157.537.5Staff ShortageT Wilkins7
908/01/2014DBTour 12510Staff ShortageT Wilkins8
1009/01/2014AATour 237.522.5Staff ShortageT Wilkins9
1110/01/2014BBTour 261060Staff ShortageT Wilkins10
1211/01/2014CATour 247.530Staff ShortageJ Doe11
1312/01/2014DBTour 2155Staff ShortageJ Doe12
1413/01/2014AATour 257.537.5Staff ShortageJ Doe13
1501/02/2014BBTour 281080Staff ShortageJ Doe14
1602/02/2014CATour 247.530Staff ShortageJ Doe15
1703/02/2014DBTour 25525Staff ShortageJ Doe16
1804/02/2014AATour 227.515Staff ShortageJ Doe17
1905/02/2014BBTour 221020Staff ShortageJ Doe18
Sheet1


Summary by Employee and Date

Excel 2010
ABCDE
2
3Column Labels
42014
5JanFeb
6Row LabelsHours WorkedTotal OwedHours WorkedTotal Owed
7A14105215
8B1919010100
9C1290430
10D945525
11Grand Total5443021170
12
Sheet5


Summarised by Tour and Hourly Rate


Excel 2010
ABC
2
3Tour and Hourly RateHours WorkedTotal Owed
4Tour 135275
55840
67.514105
71013130
8Tour 240325
95630
107.518135
111016160
12Grand Total75600
13
Sheet4
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,601
Messages
5,838,287
Members
430,537
Latest member
Antonio11

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top