Rounding time values up and down
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 |
Rounding time values up and down
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 |
Rounding time values up and down
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 |
Rounding time values up and down
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 |
All times are GMT +1. The time now is 09:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com