Rounding time to nearest Hour

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel, is there a way to round off time to the nearest hour. 6:10 would
become 6:00; 6:30 would be 7:00.
 
One way

=ROUND(A1/(1/24),0)*(1/24)

where A1 holds your time, format as time or you'll probably get a decimal
number

--
Regards,

Peo Sjoblom

(No private emails please)
 

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

formula/version 2007 2
How do I round time down to the nearest half hour? 3
Rounding hh:mm to nearest 15, 30, 45 minutes 4
Rounding (decimal) elapsed time 2
How do I round time 2
Rounding Time to Nearest 5 Minutes 1
Rounding numbers up or down in same formula 6
Alternate Rounding Up & Down of .50 in a column 5

Back
Top