Announcement

Collapse
No announcement yet.

Shift Work Time Sheet With Normal & Overtime Hours

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    Re: Shift Work Time Sheet With Normal & Overtime Hours

    Will come back this evening. (GMT+5.30)
    Kris

    ExcelFox

    Comment


    • #3
      Re: Shift Work Time Sheet With Normal & Overtime Hours

      Hi,

      Sorry for the late reply.

      Pl. find attached.
      Attached Files
      Kris

      ExcelFox

      Comment


      • #4
        Re: Shift Work Time Sheet With Normal & Overtime Hours

        great, thankyou!

        Comment


        • #5
          Re: Shift Work Time Sheet With Normal & Overtime Hours

          Originally posted by jonny5
          great, thankyou!
          You are welcome!!

          Got the payment. Thanks !
          Kris

          ExcelFox

          Comment


          • #6
            Re: Shift Work Time Sheet With Normal & Overtime Hours

            Thanks for sharing!!!

            Online Timecard

            Comment

            Working...
            X