+ Reply to Thread
Results 1 to 1 of 1

PowerPivot - Timings ignoring down hours from another table

  1. #1
    Registered User
    Join Date
    01-22-2018
    Location
    West Yorkshire, England
    MS-Off Ver
    2016
    Posts
    8

    PowerPivot - Timings ignoring down hours from another table

    Hello,

    I am trying to create a formulae in powerpivot that calculates time between two date/times, ignoring hours which are down hours

    i.e.

    If Start Time was 04/01/2018 05:53:00 and End Time was 05/01/2018 07:33:00 the answer should be 1060 minutes.

    Attached is the table. Ideally i would want to do this is PowerPivot opposed to normal formula. I hope it will be simpler anyway.

    EDIT - To confirm, any hours in the second table that has a No shouldnt be counted in the time function.

    Thanks in advance

    Harvey
    Attached Images Attached Images
    Attached Files Attached Files

+ 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. [SOLVED] PowerPivot CALCULATE ignoring filter?
    By TitansGo in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-27-2016, 04:09 PM
  2. [SOLVED] Use VLOOKUP to duplicate exp. in cashflow, using timings assigned in another table
    By STUARTXL in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-19-2016, 03:07 PM
  3. Replies: 4
    Last Post: 07-23-2015, 03:35 PM
  4. Replies: 2
    Last Post: 06-02-2014, 09:34 AM
  5. PowerPivot Table Help!
    By Twi78 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-26-2012, 11:02 AM
  6. Calculate Hours Ignoring Empty Cells
    By robinrobin in forum Excel General
    Replies: 5
    Last Post: 08-15-2010, 09:59 AM
  7. adding hours and minutes ignoring seconds
    By cbm in forum Excel General
    Replies: 4
    Last Post: 10-21-2005, 11:19 AM

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