Timesheet Undetime and Night Differential Calculations
Good day, masters!
I badly need help regarding the timesheet spreadsheet.
Summary of Attendance.xlsm
In M17, can it calculate the night differential for a schedule? For example, the night differential time starts at 10PM and ends at 6AM.
In: 10:01 PM
Out: 6:15 AM
ND: 8
In: 10:15 PM
Out: 10:59 PM
ND: 0
In: 10:00 PM
Out: 11:58 PM
ND: 1
Like it counts an additional 1hr ND everytime it consumes an hour of rendered duty.
Thank you so much!
If(out<in, (out-in+1)*24, (out-in)*24)
Diana Tanase
If the solutions offered helped you to solve your problem, then mark the thread as SOLVED (thread tools in the top menu) and you can click on * to add reputation to those who helped you, as a way to say thank you !
Thank you for the reply sir! I just want to clarify if in/out there will only involved actual time ins and outs? Not the scheduled one?Originally Posted by tanasedn
=IF(F17<E17, (F17-E17+1)*24, (F17-E17)*24)
Are the ND hours listed in post #1 the expected results?
If so, then I don't understand why 10:01 PM to 6:15 AM should be 8 and 10:00 PM to 11:58 PM should be 1.
It would seem that either the former should be 7 or the latter should be 2.
Please give us an explanation of the rules governing the number of ND hours.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Thank you for the reply sir.
The employee sir must render a complete 60-minute duration of duty before counting a 1 Night Differential Hour, which in this case, 10:00 PM to 11:58 PM , lacking 2 minutes before 12:00mn.
In that event it would seem that the ND 10:01 PM to 6:15 AM should be 7 as ND ends at 6:00 AM so the formula should count 60-minute durations from 10:01 PM to 6:00 AM
What am I missing?
Yes sir. It will only be 7 ND hours.
Assuming that this should go in column M try the following in M17:Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Thank you so much sir!!!!Assuming that this should go in column M try the following in M17:Formula:Please Login or Register to view this content.
Let us know if you have any questions.
You're Welcome and thank you for the feedback. Please take a moment to mark the thread as 'Solved' using the thread tools menu above your first post. I hope that you have a blessed day.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks