Rounding to the nearest quarter hour

[Myrdrai]

I'm using a template I found for employee timesheets and it works well but there is just one problem how do I get it to calculate the hours to the "nearest quarter hour"

EDIT: Sorry, I didn't read the guidelines before posting

Using Excel 2003, on Windows XP

=ROUND(IF((OR(B12="",C12="")),0,IF((C12<B12),((C12-B12)*24)+24,(C12-B12)*24))+IF((OR(E12="",F12="")),0,IF((F12<E12),((F12-E12)*24)+24,(F12-E12)*24)),2)

I know literally Nothing about this so I have no idea what I'm even looking at.

Thanks for all your time and patience

 

[Mark W.]

Also, choose the Tools | Options... menu command's Error Checking tab, and right-click on the "Inconsistent formula in region" check box label.

 

[Myrdrai]

ok I understand that but, the problem is that it doesnt show the correct calculations for the total hours.

For example, it should round 7.17 hours up to 7.25 or 7.33 down to 7.25

testsheet.xls
	A	B	C	D	E	F	G	H	I	J	K
8	Weekly Employee Time Sheet
9
10	Day of Week	Time In	Time Out	Meal	Time In	Time Out	Total Hrs	Regular Hrs	Overtime Hrs	Sick Hrs	Vacation Hrs
11	Sunday
12	Monday	8:00 AM	11:33 AM		12:07 PM	5:00 PM	8.50	8.00
13	Tuesday	9:00 AM	12:00 PM		1:00 PM	5:10 PM	7.17	7.17
14	Wednesday	9:00 AM	12:00 PM		1:00 PM	5:20 PM	7.33	7.33
15	Thursday
16	Friday
17	Saturday
18							Total:	22.50
19							Rate:	$8	$12	$8	$8
20							Total ($):	180.00	-	-	-
TimeSheet

 

[Myrdrai]

oh good god, it would help if I actually changed the code for the rest of the week lol

I'm really sorry about the confusion, thanks for all your help, I really appreciate it

 

[Mark W.]

ok I understand that but, the problem is that it doesnt show the correct calculations for the total hours.

For example, it should round 7.17 hours up to 7.25 or 7.33 down to 7.25

As it should...

7.17 hours is equivalent to 7 hrs 10 min 12 sec which is closer to 7:15 (7.25 hours)
7.33 hours is equivalent to 7 hrs 19 min 49 sec which is closer to 7:15 (7.25 hours)