Results 1 to 1 of 1

Identify if a date/time period exists within a calender period date and time

Threaded View

  1. 07-25-2013, 10:03 AM #1
    bajdr47
    bajdr47 is offline
    Forum Contributor
    Join Date
    03-30-2009
    Location
    dublin
    MS-Off Ver
    Excel 2007
    Posts
    104

    Identify if a date/time period exists within a calender period date and time

    Hello All,

    I have been trying to get to grips with the problem in the attached sheet, but am stuck !

    the table to the left is required to display how many people were in attendance for a 24hr period based on the date selected.

    I am having a problem with the first record and across midnight

    The ARRIVAL AND DEPART columns were added by myself not needed or desired(preferrably)

    Thank you in advance

    Baj
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Loop & Match considering location and period of date&time
    By tudorr in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2013, 06:12 AM
  2. [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
  3. [SOLVED] Complicated:Calculate time period based on no. of units sold + fluctuations within period
    By omaha.crab in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 03:04 AM
  4. Calculate future dates from start date with varying time period/cycle
    By HOWTOEXCEL in forum Excel General
    Replies: 15
    Last Post: 09-16-2009, 12:02 PM
  5. Every time i put a number with period it becomes a date and time
    By excelSOS in forum Excel General
    Replies: 7
    Last Post: 03-06-2006, 08:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1