+ Reply to Thread
Results 1 to 2 of 2

Need to round the time to the nearest quarter hour. Help

  1. #1
    John
    Guest

    Need to round the time to the nearest quarter hour. Help

    Hi, I am trying to get my spreadsheet to round to the nearest quarter hour.
    This is the current formula I am using.

    =ROUND(IF((OR(B15="",C15="")),0,IF((C15<B15),((C15-B15)*24)+24,(C15-B15)*24))+IF((OR(E15="",F15="")),0,IF((F15<E15),((F15-E15)*24)+24,(F15-E15)*24)),2)

    As you can see it to decemal with breaks included. I still need to finnish
    in decemal.

    I tried to incorpuate a couple of formulas but fail.
    =ROUND(A1*96,0)/96
    =ROUND(D13*4,0)/4

    Thanks

  2. #2
    John
    Guest

    RE: Need to round the time to the nearest quarter hour. Help

    I figure it out. Thanks

    "John" wrote:

    > Hi, I am trying to get my spreadsheet to round to the nearest quarter hour.
    > This is the current formula I am using.
    >
    > =ROUND(IF((OR(B15="",C15="")),0,IF((C15<B15),((C15-B15)*24)+24,(C15-B15)*24))+IF((OR(E15="",F15="")),0,IF((F15<E15),((F15-E15)*24)+24,(F15-E15)*24)),2)
    >
    > As you can see it to decemal with breaks included. I still need to finnish
    > in decemal.
    >
    > I tried to incorpuate a couple of formulas but fail.
    > =ROUND(A1*96,0)/96
    > =ROUND(D13*4,0)/4
    >
    > Thanks


+ Reply to Thread

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