Loading
Ozgrid Excel Help & Best Practices Forums

Excel Training / Excel Dashboards Reports



Results 1 to 6 of 6

Thread: Shift Work Time Sheet With Normal & Overtime Hours

  1. #1
    Join Date
    23rd January 2009
    Posts
    2

    Shift Work Time Sheet With Normal & Overtime Hours

    please see the attached. we have a clocking in and out system that spits out a report as a text file i then copy and paste the date, start time and finish time into the attached time sheet that rounds the time up or down to the nearest 15mins. The guys can start work at anytime day or night and ofter cross midnight.

    i need to break down the total daily hours figure into normal hours, time and
    half hours and double time hours.

    its time and half between 20:00 and 05:00 and also goes onto time and half
    after 10 hours
    sunday are double time all day

    so if someone works mon - sat 04:00 until 16:00 per day that would break down as
    total 12hrs - 9hrs regular 3 hrs at time and a half.

    if they work sat 18:00 until 03:30 on sunday that would break down as
    total 9.5hrs - 2hrs regular, 4hrs at time and a half, 3.5hrs at double time.

    at the moment i fill these columns in with pencil but i'd like it to work them out automatically when i copy and paste the info from the clocking system,

    I can pay $25 for help doing this
    thankyou
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  2. #2
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Shift Work Time Sheet With Normal & Overtime Hours

    Will come back this evening. (GMT+5.30)

  3. #3
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Shift Work Time Sheet With Normal & Overtime Hours

    Hi,

    Sorry for the late reply.

    Pl. find attached.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

  4. #4
    Join Date
    23rd January 2009
    Posts
    2

    Re: Shift Work Time Sheet With Normal & Overtime Hours

    great, thankyou!

  5. #5
    Join Date
    18th November 2004
    Location
    God's Own Country
    Posts
    4,648

    Re: Shift Work Time Sheet With Normal & Overtime Hours

    Quote Originally Posted by jonny5
    great, thankyou!
    You are welcome!!

    Got the payment. Thanks !

  6. #6
    Join Date
    25th May 2010
    Posts
    1

    Re: Shift Work Time Sheet With Normal & Overtime Hours

    Thanks for sharing!!!

    Online Timecard

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Possible Answers

  1. Track/Calculate Overtime Hours- Daily Basis
    By neiltron in forum Excel General
    Replies: 6
    Last Post: July 4th, 2013, 00:26
  2. Calculate Overtime Hours
    By markjarvis25 in forum Excel General
    Replies: 5
    Last Post: August 7th, 2008, 12:28
  3. Replies: 8
    Last Post: April 14th, 2008, 13:00
  4. Conditional Format Shift Overtime Times
    By Biz in forum Excel General
    Replies: 1
    Last Post: February 22nd, 2008, 07:27
  5. Calculating Hours Worked With Overtime Clause
    By error#9 in forum Excel General
    Replies: 8
    Last Post: July 25th, 2007, 01:24

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
porno