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-05-2017, 01:52 PM #8
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,123
    Rep Power
    10
    Hi

    If I understood correctly, you can add one more column at the end to highlight which is the normal working day or holiday rather than coloring the cell.

    Please find attached.

    HTH
    Attached Files Attached Files
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    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