Hi everyone!
My problem is how can I plot the excess of 8 hours worked in a day of an employee. What I want to do is create a formula that will plot the excess 8 hours worked and recognized the non-working days (e.g. Saturday, Sunday and declared holidays). See attached sample file
Thank you in advance.
What do you mean by "plot"?
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
What I mean is that the cell recognize or can determine the time that is over/beyond 8 hours.
sample_time ploting.xlsx
Please see attched.
You can add more dates to the left hand side
Thank you for helping me plotting the time especially on holidays, but there's one thing that I really need to solve. Here's what i want to happen:
If I logged in (time in @column B) at 9:00 and logged out (time out @ column C) at 20:00, column D will determine or plot the time 19:00 (for this the excess or beyond 8 hours of work (less 1 hour non-working time 12:00-13:00)). For column E, will only replicate the data entered at column C.
Thanks again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks