Rounding time values up and down "durbat2[ at ]googlemail.com" <mn.bagshaw[ at ]btinternet.com> 12/31/2008 6:53:15 PM 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

Re: Rounding time values up and down google[ at ]magneticnorth.ca 12/31/2008 7:00:44 PM 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

Re: Rounding time values up and down "David Biddulph" <groups [at] biddulph.org.uk> 12/31/2008 7:01:46 PM 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 durbat2[ at ]googlemail.com wrote: [Quoted Text] > 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

RE: Rounding time values up and down Eduardo 12/31/2008 7:02:01 PM Hi, Take a look at CPearson web http://www.cpearson.com/excel/datetime.htm#RoundingTimes If this helped you please say yes, thank you "durbat2[ at ]googlemail.com" wrote: [Quoted Text] > 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 >