Results 1 to 18 of 18

Net work hours Calculation

Threaded View

  1. #1
    Registered User
    Join Date
    06-11-2021
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    10

    Post Net work hours Calculation

    Hi, i have a similar question and mentioned below

    Start date in F2 Column 5/13/2024 3:36:32 AM
    End date in G2 Column 5/15/2024 10:38:40 AM

    from start & end date time calculate the working hours from start shift day is 8pm in AX3 column to End shift day is 7am AY3 Column by excluding the weekend and holiday range AU2:AU12 need a excel formula. Thanks
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Work hours calculation
    By Eric Tsang in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-17-2022, 01:15 PM
  2. [SOLVED] Work hours calculation with break deduction
    By Unca Wook in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-14-2020, 10:03 AM
  3. Replies: 5
    Last Post: 09-12-2019, 04:16 AM
  4. Calculation work hours
    By PatsFan12 in forum Excel General
    Replies: 4
    Last Post: 01-29-2019, 10:50 AM
  5. [SOLVED] Work Week Hours Calculation problem
    By laughingasian in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-23-2012, 11:32 AM
  6. Excel Work Hours and Time Calculation Help
    By watchoverme in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-04-2012, 03:14 AM
  7. [SOLVED] Removing non Work Hours from Excel calculation
    By lindaho98@hotmail.com in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 03-10-2006, 09:31 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1