Results 1 to 13 of 13

How do I create a formula to count multiple events in a set time period ex 8 am to 10 pm

Threaded View

  1. #9
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: How do I create a formula to count multiple events in a set time period ex 8 am to 10

    Why make thing complicated???

    =HOUR(TIMEVALUE(TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"AM"," AM"),"PM"," PM"),11,25)))) - MOD(HOUR(TIMEVALUE(TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1,"AM"," AM"),"PM"," PM"),11,25)))),2)


    It's very simple formula:

    =HOUR(A1)-MOD(HOUR(A1),2)
    Last edited by Teethless mama; 12-11-2012 at 10:34 PM.

Thread Information

Users Browsing this Thread

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

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