Results 1 to 8 of 8

Formulae required to distinguish between start and end time.

Threaded View

  1. #1
    Registered User
    Join Date
    09-22-2012
    Location
    Nottingham, Uk
    MS-Off Ver
    Excel 2007
    Posts
    4

    Formulae required to distinguish between start and end time.

    I require a formuale that will when amending the time in either column "B" or "C" that spans past midnight eg row 52 will start to populate column"H" onwards to the respective column that has a heading equal to the time in column "C" with the number 1 or a number 0 where the time frame includes that of coolumns "D" and "E"
    I can get this to work fine up to midnight but not after midnight for example if the time start is 22:00 and end time is 06:15 my formuale only works to 00:00

    Hope this makes sense ?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formulae required for serial number
    By accountant. in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 04-20-2013, 01:05 PM
  2. Replies: 0
    Last Post: 07-17-2012, 10:11 AM
  3. Replies: 3
    Last Post: 03-27-2012, 01:07 PM
  4. excel formulae required
    By vmprakash in forum Excel General
    Replies: 2
    Last Post: 09-03-2010, 03:28 AM
  5. Excel 2007 : Formulae required for a stock report
    By lindalou in forum Excel General
    Replies: 4
    Last Post: 04-21-2009, 08:14 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