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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Need to round the time to the nearest quarter hour. Help (https://www.excelbanter.com/excel-discussion-misc-queries/71016-need-round-time-nearest-quarter-hour-help.html)

John

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

John

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

All times are GMT +1. The time now is 05:08 PM.