How do I round time to the nearest quarter of an hour
If you want the answer in decimal hours use this formula and format the cell
as a number
=ROUND(A1*24*4,0)/4
If you want the answer in Excel time use this formula and format the cell as
time
=ROUND(A1*24*4,0)/24/4
These round to the nearest quarter hour so 4:17 will yield 4.25 or 4:15
"Meghan" wrote:
I am not too understanding of excel to any great extent. But I need to round
time to the nearest quarter.
Example
8:11 to 8.25
4:41 to 4.75
|