Post images into Excel? Really? I gotta try that!
Chai, why do you copy your screen for coworkers , or print it for whatever? For work? What is the use, if you don't mind? (Always wanna know if I can do what I do easier or more efficiently)...
Yes, it's for work.
It's to show a summary of the previous pages tracking employees overtime hours, and when they were incurred.
Actually, I just realized, I lied....It's only 7 print screens, one for each day of the week, but each screen shows what 20 employees were doing on that day.
If I may....
On each sheet, across the top, is each persons name....Joe, Betty, etc.
I'll take the time cards of each person and enter this....
In the cell under Joe's name, I enter their start time, in military time, i.e.
In the cell below that, I enter their end time, i.e.
21:00....meaning they worked 16 and a half hours
This is the part I like....Below the times, I made it so the rows represent a 24 hour peroid, from 00:00 to 24:00.
When the times are entered, formulas I put in hidden columns cause the appropriate cells for the entered time in that column to turn either green for regular time, and red for OT.
The informatin entered on one sheet transfers to the next sheet, so as soon as a person hits over 40 hours, all subsequent cells for hours worked will be colored red.
The 7 sheets are linked together by clicking on the employees name, taking you to the "In" time on the next sheet for that particular person.
Anyway, you're then able to see that Joe started going into overtime on Wed, and not only that, but why was he working until 23:30 hours? (pretty much normal times would be anywhere from 04:00 to maybe 19:00)
I could have left it like that, but being able to see the entire week on one summary page, rather than someone having to click from sheet to sheet, seemed more user friendly. If they print is out, they can just look at the whole week in one chunk.