Rounding Time values

  • Thread starter Thread starter mebsmith
  • Start date Start date
M

mebsmith

I am looking to round a time field such as this:

6:40:00 AM

to the nearest hour, keeping it in a format so that it can be displayed in
24hr format for easy identification as to the time of day. Even keeping the
AM/PM would be fine too.

Any suggestions? I have exhausted all the ones i thought would work.

Thanks
 
Heres a function to calculate and display results, replace A1 with whatever
cell your time value is in.

=TIME(IF(MINUTE(A1)>30, HOUR(A1)+1,HOUR(A1)),0,0)
 
Back
Top