Results 1 to 10 of 29

Thread: Code Required to calculate number of days worked, normal overtime and holiday overtime

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-07-2017, 10:03 PM #20
    nelsondavid
    nelsondavid is offline
    Junior Member
    Join Date
    Jan 2017
    Posts
    9
    Rep Power
    0
    Dear Alan,

    25 days ABSENT ,i.e, Absent 4 days plus one holiday (4 days) -29,31,9,19 and 30 (the employee did not come on 29 and 31 so 30 holiday marked as absent)

    If Question 2 scenario arises holiday is considered present

    Sample attached

    Thanks,

    Nelson
    Attached Files Attached Files
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. VBA Code To Send Automatic Mail Reminder For Meeting X Days In Advance
    By exceldumby in forum Hire A Developer
    Replies: 33
    Last Post: 01-12-2015, 10:08 AM
  2. Absolute amount or IF and Greater than Formula Code Required
    By aaron.mendes in forum Excel Help
    Replies: 1
    Last Post: 07-23-2013, 10:43 PM
  3. Projected Depreciation calculated as per number of days.
    By Suhail in forum Excel Help
    Replies: 0
    Last Post: 09-17-2012, 02:05 PM
  4. The Number of Years, Months and Days Between Two Dates
    By Rick Rothstein in forum Rick Rothstein's Corner
    Replies: 7
    Last Post: 06-08-2012, 10:35 PM
  5. Number of Days In A Month
    By Excel Fox in forum Excel and VBA Tips and Tricks
    Replies: 0
    Last Post: 05-14-2011, 08:00 PM

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
  •  

Forum Rules