+ Reply to Thread
Results 1 to 2 of 2

Help with assigning value/linking data

  1. #1
    Registered User
    Join Date
    01-08-2019
    Location
    Georgia
    MS-Off Ver
    My Office 365
    Posts
    1

    Help with assigning value/linking data

    I need help making the "Early Out" count for 0.5 or 1/2 day instead of 1.

    Also, you'll see on Employee 3 that even though the dates out were from 1/5-1/7, the "Days" column still only calculates as 1?

    (I downloaded this sheet from Excel templates.)

    Thanks!
    Attached Files Attached Files
    Last edited by 6StringJazzer; 01-08-2019 at 11:43 AM. Reason: Moved from Excel General

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Help with assigning value/linking data

    Please try at F4 copy down

    =IF(LEFT(E4,5)="early",0.5,NETWORKDAYS(C4,D4,lstHolidays))


    Networkdays only count Mon-Fri.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Assigning data dynamically
    By JohnTopley in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-30-2021, 10:46 AM
  2. Looping through data and assigning data to a dictionary value
    By AB91 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-18-2017, 04:48 PM
  3. Assigning data dynamically
    By JohnTopley in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-15-2015, 02:35 PM
  4. linking incompatible spreadsheeets and linking data in summary sheet
    By tcarter1208 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-24-2015, 04:02 AM
  5. [SOLVED] Counting specific data and extracting that data by rearranging by assigning numbering
    By paradise2sr in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-25-2014, 07:11 AM
  6. Linking/Assigning a combo box to a pivot table
    By The Fly in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-08-2014, 09:37 AM
  7. Assigning Values from Fixed Data Set to Variable Data Set
    By Jaricketts in forum Excel General
    Replies: 4
    Last Post: 04-21-2010, 01:24 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