Round to nearest

[Robert Wyatt]

I'm trying to get my time to round to the nearest .15 minutes,.25 minutes and .50 minutes. I have included a L2BB showing what I have. Could you please tell me what it is I'm doing wrong?

Book1
	A	B	C	D	E	F
1	IN	OUT	IN	OUT	HOURS	MROUND
2	5:00 PM			9:46 PM	4.77	4.77
3	5:00 PM			10:16 PM	5.27	5.27
4	4:00 PM			10:16 PM	6.27	6.27
5	6:00 PM			10:16 PM	4.27	4.27
6					0.00	0.00
7					0.00	0.00
8					0.00	0.00
9				Total Hrs:	20.58	20.58
10				Should Be:	20.50
Sheet1

Cell Formulas
Range	Formula
E2:E8	E2	=ROUND(IF((OR(A2="",D2="")),0,IF((D2<A2),((D2-A2)*24)+24,(D2-A2)*24))+IF((OR(C2="",B2="")),0,IF((B2<C2),((B2-C2)*24)+24,(B2-C2)*24)),2)
F2	F2	=MROUND(E2,0.15/(60*24))
F3:F8	F3	=MROUND(E3,15/(60*24))
E9:F9	E9	=SUM(E2:E8)

 

[Sufiyan97]

Try

=MROUND(E2,0.15)

 

[Robert Wyatt]

Try

=MROUND(E2,0.15)

Thank you for the help. If it had been a snake, it would have bitten Me. lol

 

[Sufiyan97]

Well, looks like I saved you from an Excel 'panic attack'! You're welcome!

 

[Joe4]

Robert,

Please Note: In the future, when marking a post as the solution, please mark the post that contains the solution (not your own post acknowledging that some other post was the solution).
When a post is marked as the solution, it is then shown right underneath the original question so people viewing the question can easily see the question and solution in a single quick glance without having to hunt through all the posts.

I have updated this thread for you.