I thought I had this projected completed, but it turns out that I did not account for overtime days.
Right now, I have my sheet set up to track the 5 - 24 hours work days in a pay period. The trouble is
I did not account for any extra days that might be worked in the pay period. The way our work cycle is
set up, it is possible to work a total of 8 shifts per pay period (unlikely). I can just add 3 more worksheets
and then continue to total it the way I do. But, it is already too "busy" on the home page, so my thought
is to collect all the data on one worksheet, thus avoiding 8 different sheets. That is fine, I could add a date column and
then just have one worksheet (which doesn't sound too bad).
My formula's are set up to add all the time for each work day (24 hours), then round based off the total for that day.
If I make it on one worksheet, I would have to somehow group the entries into each work date, so I could be able
to round my time based off of the date. I know how to group with pivot tables, but I don't think I can use a pivot
the way this is set up? or not sure if that would even be a good idea.
Look for suggestions on how I can set this up so I can collect this data on one worksheet.
Thanks expertcompile.xlsx expertcompile.xlsx