Computing for number of hours under Night Differential
I am just a newbie here. I want to ask for your help. I was tasked to make our time report sheet and they want to indicate the number of hours worked between 10pm to 6 am (column in RED) for purposes of computing the night shift differential.
I am attaching the excel file.
I have two cells in my Excel file that contains the Start and Stop time, I was able to get the time difference between the 2 cells. Their cell format is dd/mm/yy 00:00 PM/AM (Custom).
I want to get the time differential (night shift) between the two cells but I can't figure it out. Night shift starts at 10:00 PM - 6:00 AM (next day), please see sample below.
C2: 08-July-2010 8:00 PM (Start)
D2: 09-July-2010 8:00 AM (Stop)
Would appreciate if you could help me build a formula to get the time accumulated for night differential.
Need a help on this query: I need to compute the number of Voluntary Time Off within 8 hours shift.
B4 = 5:00 PM - 2:00 AM <-- Shift Line
B5 = 5:00 PM <-- log in time
C5 = 12:11 AM <-- log out time due to VTO
D5 = 1:49 <-- VTO hours
How will I be able to do this to avoid computing it manually?
I am not sure how to write the formula which will return the meal allowance and night differential rate for each of the employees who worked overtime.
Regular working days and hours are : M-F, 8-5 pm
An employee is entitled to receive a $5 meal allowance if:
- On Holidays and Weekends : Overtime worked went beyond 12nn or 7pm (a total of $10 if worked before 12nn until past 7pm;
- On Regular days (M-F): Overtime worked beyond 7pm
The night differential rate is earned if overtime worked is rendered beyond 10pm on any day.
I have attached a sample worksheet that I am working on.
I have attached a file. In our office we have an 8hr workday that's 8am-5pm. However, we have this what we call as flextime wherein we can come to work late for up to 30mins that's up to 8:30 provided that we will go out 30mins late as wee that's up to 5:30. We also have a 1hr (12nn-1pm) lunch break from which we can time in/out between 12NN-1PM.
My problem is: how to compute for the total number of work hours and minutes (this is in case the employee goes under time or beyond flextime)?
Related Applications & Scripts
Simple, just drag and drop the clip on your scene and its work.
Turn your favourite digital image into a jigsaw. Solve it offline in a browser or use it as a puzzle on your webpage. This free java applet features pieces shaped by template to size specified by user.
- Attractive design
- Unlimited slider
- Html Support
- Email Validation
- Different Background Options
VNC++ (an abbreviation for Virtual Network Computing) is a great client/server software package that allows remote network access to graphical desktops.
With VNC++, you can access your machine from everywhere provided that your machine is connected to the Internet. VNC++ is free (released under the GNU General Public License and it's available on most platforms.
VNC++ is an enhanced version of TightVNC, which includes a new feature, in addition to bug fixes over the original TightVNC version, see the list of features below.
Note: that VNC++ is still free, cross-platform and compatible with TightVNC.
VNC++ can be used to perform remote control and administration tasks in Windows, UNIX and mixed network environments. It can be very helpful in distance learning and remote customer support.
A 3D rendering of a city with animated lights and freeway traffic. This was created for use as a background animation for banners.
The animation is contained in its own movieclip. Just drag and drop it into your Flash banner project. Original size is 454 pixels wide by 600 pixels high but it can be scaled down or squashed as needed.
FLA file in CS3 format, minimal code is compatible with both ActionScript 2.0 and 3.0.