Rounding time values up and down

[durbat2]

Sorry if this has been asked before but i have time values in cells
formatted h.hh
I need to round the values to the nearest hour for example a time of
13:15 needs to be rounded to 13 and a time of 08:45 would be rounded
to 09

Hope this makes sense

Martin

 

[google]

If you multiply by 24 (hours in a day), round it off, then divide by
24, it appears to work.

e.g. =ROUND(A1*24,0)/24

 

[David Biddulph]

I don't understand the logic of formatting as h.hh. Why would you want to
display 13:15 as 13.13 ?

If you've got a number in Excel time format, =MROUND(A1,1/24) will round to
the nearest hour, and you can then format to suit your requirements (which
sounds like hh).

 

[Eduardo]

Hi,
Take a look at CPearson web

http://www.cpearson.com/excel/datetime.htm#RoundingTimes

If this helped you please say yes, thank you