Results 1 to 12 of 12

count time after midnight

Threaded View

tcowen count time after midnight 10-29-2009, 02:29 PM
khamilton Re: count time after midnight 10-29-2009, 03:13 PM
LeeGlide Re: count time after midnight 10-17-2011, 09:58 AM
daddylonglegs Re: count time after midnight 10-17-2011, 10:18 AM
khamilton Re: count time after midnight 10-29-2009, 03:18 PM
WHER Re: count time after midnight 10-29-2009, 03:28 PM
modytrane Re: count time after midnight 10-29-2009, 03:29 PM
modytrane Re: count time after midnight 10-29-2009, 03:31 PM
tcowen Re: count time after midnight 10-29-2009, 04:45 PM
  1. #1
    Registered User
    Join Date
    03-08-2004
    Posts
    12

    count time after midnight

    This is a follow up to another thread of same name.

    =(($a1<=BR$4)+($b1>BR$4)+($a1>$b1)=2)+0

    so If a1 = 18:00 and B1 = 02:30 then 19:00 or 01:00 in BR4 will give a 1 but 03:00 will give a zero, is that what you need?

    Of course the formula still works if your shift doesn't pass through midnight....
    I was not able to get the formula to work as previously described, but perhaps I am not looking at it correctly. I have attached a sample workbook of what I am trying to accomplish and would appreciate some tweaking of the formula.
    The formula works for shifts between 0000 and 2400 but does not when crossing over midnight.
    I would also like to understand the logic behind the formula. I know it has to do with T/F conditions, but I'm confused about the "2" in the formula.

    Thanks,
    TC
    Attached Files Attached Files
    Last edited by tcowen; 10-29-2009 at 04:45 PM.

Thread Information

Users Browsing this Thread

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

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