View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
Sloth Sloth is offline
external usenet poster
 
Posts: 252
Default 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