Results 1 to 5 of 5

Calculate Weekdays and Weekends Separately

Threaded View

  1. #1
    Registered User
    Join Date
    07-29-2021
    Location
    South Africa
    MS-Off Ver
    365
    Posts
    9

    Question Calculate Weekdays and Weekends Separately

    Good day

    Hope everyone is doing well. I need assistance with attached time sheet

    I need to Calculate regular hours on the sheet under regular hours

    Then Saturday and Sunday need to be overtime hours and not regular hours

    Then totals for regular hours and overtime hours

    Hope all this makes sense.


    Your assistance would be greatly appreciated.
    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. Count specific text for weekdays and weekends separately.
    By Mozzieman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-10-2019, 11:58 AM
  2. [SOLVED] SUMIFS for weekdays/weekends
    By Davzx in forum Excel General
    Replies: 5
    Last Post: 09-27-2015, 11:56 AM
  3. Calculate based on weekdays & weekends
    By Ichigo in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-12-2015, 12:37 AM
  4. Turning weekends into weekdays?
    By bobing in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 09-16-2013, 06:34 AM
  5. WEEKENDS VS. WEEKDAYS
    By TLAngelo in forum Excel General
    Replies: 0
    Last Post: 07-10-2006, 02:04 PM
  6. [SOLVED] WEEKENDS VS. WEEKDAYS
    By TLAngelo in forum Excel General
    Replies: 7
    Last Post: 05-12-2006, 12:35 PM
  7. IF statement with Weekends vs. weekdays
    By edwardpestian in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-07-2006, 04:13 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