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

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

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).
--
David Biddulph

wrote:
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

Hi,
Take a look at CPearson web

http://www.cpearson.com/excel/dateti...#RoundingTimes

If this helped you please say yes, thank you

" wrote:

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