Rounding time down at 5 mins and up at 6 mins past quarter hour

[VOR]

Hi All,
I am looking for some help with a formula that will round down if 5 mins past the quarter of hour or round up to the next quarter of the hour if 6 mins past
Examples

[TABLE="width: 500"]
<tbody>[TR]
[TD]10:01[/TD]
[TD]Result would be 10:00[/TD]
[/TR]
[TR]
[TD]10:04[/TD]
[TD]Result would be 10:00[/TD]
[/TR]
[TR]
[TD]10:06[/TD]
[TD]Result would be 10:15[/TD]
[/TR]
[TR]
[TD]10:15[/TD]
[TD]Result would be 10:15[/TD]
[/TR]
</tbody>[/TABLE]


Currently using =ROUND(F5*(24*60/15),0)/(24*60/15) but this rounds down at 7 mins and up at 8 mins

Need rounds down at 5 mins and up at 6 mins

Thanks

 

[wideboydixon]

Book1
	A	B
1	10:01	10:00
2	10:04	10:00
3	10:06	10:15
4	10:15	10:15
5	22:35	22:30
6	22:36	22:45
7	23:51	00:00
Sheet1

Cell Formulas
Range	Formula
B1	=TIME(HOUR(A1),INT((MINUTE(A1)+9)/15)*15,0)

WBD

 

[shg]

Another way:

[Table="width:, class:grid"][tr][td="bgcolor:#C0C0C0"][/td][td="bgcolor:#C0C0C0"]

A​

[/td][td="bgcolor:#C0C0C0"]

B​

[/td][td="bgcolor:#C0C0C0"]

C​

[/td][/tr][tr][td="bgcolor:#C0C0C0"]

1​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][td="bgcolor:#F3F3F3"]

​

[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

2​

[/td][td]

10:01​

[/td][td="bgcolor:#E5E5E5"]

10:00​

[/td][td]B2: =MROUND(A2 + "0:1:30", "0:15")[/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

3​

[/td][td]

10:04​

[/td][td="bgcolor:#E5E5E5"]

10:00​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

4​

[/td][td]

10:06​

[/td][td="bgcolor:#E5E5E5"]

10:15​

[/td][td][/td][/tr]
[tr][td="bgcolor:#C0C0C0"]

5​

[/td][td]

10:15​

[/td][td="bgcolor:#E5E5E5"]

10:15​

[/td][td][/td][/tr]
[/table]

 

[VOR]

Thank you WBD, your a star

 

[VOR]

Thank you SHG