+ Reply to Thread
Results 1 to 2 of 2

IF/THEN on Blood Collection Times Post COVID-19 Test Using Date/Time

  1. #1
    Registered User
    Join Date
    04-29-2021
    Location
    Gainesville, Georgia
    MS-Off Ver
    Excel 365
    Posts
    1

    IF/THEN on Blood Collection Times Post COVID-19 Test Using Date/Time

    I'm trying to write an IF/THEN formula regarding time (military time) since a sample draw.

    Blood collection from before the test date/time to 24 hours post COVID test is DAY 0, 24-48 hours post test is DAY 1 and 48-72 hours post test is DAY 2.
    Example: A COVID test was done on 4/25/21 19:35 ($M$4 is the COVID test date/time) and blood was collected on 4/26/21 05:20. It should still be Day 0 but it's popping up as Day 2
    .
    I had a formula that seemed to be working but on some cells it doesn't.

    Here is the formula I've been working on:
    IF(AND(DAY($M$4)=DAY($A7),$A7-$M$4<1),"DAY 0",IF(AND(DAY($A7)>DAY($M$4),$A7-$M$4>=1,$A7-$M$4<2),"DAY 1",IF(AND(DAY($A7)>DAY($M$4),$A7-$M$4>=2,$A7-$M$4<=3),"DAY 2",IF(AND(DAY($A7)>DAY($M$4),$A7-$M$4>3),"Over 2 Days"))))

  2. #2
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: IF/THEN on Blood Collection Times Post COVID-19 Test Using Date/Time

    Hello Amy EH.

    Welcome to the forum.

    I believe an uploaded sample file will be most helpful. Note the instructions for doing that in the 'gold' banner at the top of this page.
    Dave

+ 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. Staff Covid Test Outcomes by Week - How To Pivot Bar Chart
    By vwhite in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-21-2021, 02:52 PM
  2. [SOLVED] Function to randomly output date/time between to fixed date/times
    By 160998 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2018, 02:49 AM
  3. [SOLVED] Time as an elapsed value, not date and time or period between two date times
    By stephenbooth_uk in forum Excel General
    Replies: 2
    Last Post: 05-31-2013, 12:50 PM
  4. Current Date and time logic test
    By jteezy73 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-25-2012, 05:48 AM
  5. Date, Time and Shift hour collection other than IF statements
    By Worker09 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-14-2010, 09:02 PM
  6. [SOLVED] Test plus date and time
    By Kelly in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-12-2005, 03:55 PM
  7. Chart to monitor Blood Pressure readings and date
    By wvincent642 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-27-2005, 01:05 PM

Tags for this Thread

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