timesheet sum but then mround to the nearest 15 mins

[tia1971]

Ok I can't understand exactly how to get a sum of the time in and out then time in and out after lunch but I need it to calculate by the 15 minutes

8/7/2018
IN OUT
7:45 AM 12:00 PM
12:30 PM 4:00 PM
7:45 The formula i have is =SUM(G21-F21)+G22-F22 but I need the 7:45 to read as 7.75 hours. Not as a clock time.
I need it to round to the 15 minutes of the hour. I have tried changing the format of the cell to different formats but still not getting what I need.

 

[Scott Huish]

=MROUND(((G21-F1)+(G22-F22))*24,0.25)

Format as General

 

[Dave Patton]

Excel 2010
	A	B	C	D
1	Date	In	Out
2	7-Aug-18	7:45 AM	12:00 PM
3		12:30 PM	4:00 PM	7.75
4
5		07:45	12:00
6		12:30	15:50	7.5
7
8		7:45 AM	12:00 PM
9		12:30 PM	4:16 PM	8.00
6b

Cell Formulas
Range	Formula
D3	=(C2-B2+C3-B3)*24
D6	=FLOOR((C5-B5+C6-B6)*24,0.25)
D9	=FLOOR((C8-B8+C9-B9)*24,0.25)

 

[tia1971]

Thank you both so much. I was able to get the =floor to work on the set up I have after changing the cell numbers to match mine.

 

[tia1971]

Also the format with General worked perfect for the total!!!