Results 1 to 10 of 10

Calculation based on multiple conditions

Threaded View

  1. #1
    Registered User
    Join Date
    01-13-2015
    Location
    WI
    MS-Off Ver
    Office 2013
    Posts
    46

    Calculation based on multiple conditions

    Im looking to perform subtraction of time in multiple columns. I'm thinking this may be a IF logic.

    What I'm trying to calculate is how long a person waits in a room by themselves until the next person comes to see them.

    Starting with column N and going right. row 2-4 is where I'll be looking. Calculating the wait time is the goal. I want excel to look at various options to calculate this.

    For example in row 2, Starting at O, provider left at 818 and the MA came in at 819. the wait time of 1 min would populate P. MA leaves at 8:22 and then next person doesn't come in till column AE at 8:24. the next wait time column I want it to populate is Column AB and leave the W and S wait time columns blank.

    But..for example in row 4 this is a different scenario. More times are entered so excel will calculate the wait time to populate S, W and AB, but leave P blank.

    Thanks for your help.
    Attached Files Attached Files
    Last edited by doop4204; 06-19-2015 at 01:11 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 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