Rounding time values up and down

D

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
 
G

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rounding hh:mm to nearest 15, 30, 45 minutes 4
Rounding to Nearest 250 6
advice on rounding or ceilng a 24 hour time value 3
How do I round to the nearest 5? 2
Excel Time Rounding in Excel 2
How do I round time down to the nearest half hour? 3
rounding time question 3
Rounding Time to Nearest 5 Minutes 1

Top