Round time off to nearest 15 minutes and then convert format

[Purple_Haze]

I'm struggling to work out a formula to round off time to the nearest 15 minutes.

Basically the numbers are timesheet entries and they need to be rounded in the following format:

Current Format	Desired Output
02:19:04	2.5
01:37:00	1.5
03:55:23	4

<tbody>
</tbody>

I've been able to round it in decimal points, but just can't get the formula to work perfectly.

This is what I have done...

First calculation:
=HOUR(R[4]C[-3]) + MINUTE(R[4]C[-3]) /60 +SECOND(R[4]C[-3]) / 3600
Second calculation:
=FLOOR(RC[-2],0.25)

It's not working, so I must be completely wrong. Any help would be much appreciated!

 

[Fluff]

Do you want to round up, round down, or round to the nearest 0.25?

 

[Purple_Haze]

Do you want to round up, round down, or round to the nearest 0.25?

Looking to round it to the nearest 0.25

 

[Fluff]

In that case, how about

Book1
	A	B
2	02:19:04	2.25
3	01:37:00	1.50
4	03:55:23	4.00
List

Cell Formulas
Range	Formula
B2	=MROUND(A2*24,0.25)

 

[Purple_Haze]

In that case, how about

	A	B
2	02:19:04	2.25
3	01:37:00	1.50
4	03:55:23	4.00

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
</tbody>

List​

Worksheet Formulas Cell Formula B2 =MROUND(A2*24,0.25) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

This worked perfectly! Thanks Fluff!

 

[Fluff]

You're welcome & thanks for the feedback