Results 1 to 2 of 2

Excel 2007 : Overtime computation

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-16-2012
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    105

    Overtime computation

    Hi

    Please help me regarding my excel time sheet formula. It's about computing the overtime, it has a condition that's why I can't think the right formula. The conditions are as follows:

    1. every week days (i.e. every Mondays to Fridays) overtime will start at 6:00 AM.
    2. on week ends (i.e. every Saturdays and Sundays) break time (12:00 PM to 1:00 PM) is not counted or not included in overtime computation.


    Attached is my sample time sheet. Some of the areas are already formulated such as the tardy and undertime.

    Any help is greatly appreciated.

    Thank you in advance.

    Gerard
    Attached Files Attached Files

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