+ Reply to Thread
Results 1 to 3 of 3

How many hours are between midnight till 22:00 and between midnight till 6:00

  1. #1
    Forum Contributor
    Join Date
    12-05-2015
    Location
    Albania
    MS-Off Ver
    2013
    Posts
    215

    How many hours are between midnight till 22:00 and between midnight till 6:00

    Hello Excel Gurus
    I'm sure the title is not clear but in this example belowe you will understand better because I wrote the expectd result in Column E and H
    As you can see I'd like to know in colum E how many hours are included in the range of time 22:00 / 00:00 n colum H how many hours are included in the range of time 00:00 / 6:00 AM
    Thank You for your help

    A
    B
    C
    D
    E
    F
    G
    H
    1
    From 22:00
    From 00:00
    2
    Till 00:00
    Till 06:00
    3
    IN
    OUT
    Result
    Result
    4
    23:00
    7:00
    1:00
    06:00
    5
    22:00
    3:00
    2:00
    03:00
    6
    20:00
    1:00
    2:00
    01:00
    7
    8:00
    23:00
    1:00
    8
    1:00
    5:00
    04:00
    9
    5:00
    0:00
    2:00
    01:00
    10
    22:00
    23:00
    2:00
    06:00

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: How many hours are between midnight till 22:00 and between midnight till 6:00

    Are you familiar with how Excel stores dates/times? If not, I recommend starting with something like this: http://www.cpearson.com/Excel/datetime.htm
    Assuming these are real time values (and not text strings that look like time), something like =1-max(A4,10/24) should 22:00 to 0:00 value. Something like =MIN(B4,6/24) should give you the 0:00 to 6:00 value.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    12-05-2015
    Location
    Albania
    MS-Off Ver
    2013
    Posts
    215

    Re: How many hours are between midnight till 22:00 and between midnight till 6:00

    Hello MrShorty
    Now is working
    Thank you for yor Help

+ 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. Hours After Midnight
    By snagger99 in forum Excel General
    Replies: 4
    Last Post: 01-06-2017, 12:59 AM
  2. How to calculate hours when it goes after midnight.
    By gps08 in forum Excel General
    Replies: 13
    Last Post: 06-21-2014, 04:19 PM
  3. Replies: 1
    Last Post: 06-03-2014, 06:28 PM
  4. Sum till the column till the date match
    By ursanil in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2014, 06:29 AM
  5. Hours after midnight
    By maniootek in forum Excel General
    Replies: 12
    Last Post: 01-11-2014, 02:44 PM
  6. [SOLVED] Calculating hours worked beyond midnight
    By Boville in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-25-2012, 12:22 PM
  7. count hours past midnight
    By cojast in forum Excel General
    Replies: 3
    Last Post: 07-01-2008, 03:53 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