Purple_Haze
New Member
- Joined
- Jun 30, 2019
- Messages
- 3
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:
<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!
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!