+ Reply to Thread
Results 1 to 1 of 1

Calculating Overtime Hours

  1. #1
    Forum Contributor
    Join Date
    08-19-2009
    Location
    Netherlands, Amsterdam
    MS-Off Ver
    Excel 2010
    Posts
    585

    Calculating Overtime Hours

    Hi all,

    I prepared something to calculate overtime hours.
    By giving a start and end time it will calculate the extra worked hours based on an 8,5 hours workday. It will deduct half an hour rest if the total worked time is more than 360 minutes.

    every extra worked minute between monday 0000 hours and friday 2400 hours are increased with 30%

    Between saturday 0000 and sunday 2400 with 50%

    However how do I calculate if someone works extra hours from lets say friday 2200 till saturday 0230

    Is there a way to calculate this?
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1