Rounding time

  • Thread starter Thread starter Christian Davidsson
  • Start date Start date
C

Christian Davidsson

Hello,

Is it possible to round a time (hh::mm) to the closest hour? If so - how?

Thanks in advance,
Christian Davidsson
 
Is it possible to round a time (hh::mm) to the closest hour? If so - how?
Click to expand...

Time is stored as fractions of days, so 24 hours = 1.0. So try

=ROUND(SomeTime*24,0)/24
 
Ah,

Thank you - the =ROUND(NOW()*24;0)/24 was the one I was looking for. Works
just the way I want it to, and thanks for the swift answer.

Cheers,
Christian Davidsson
 
Hi Christian!

Always pleased to help and thanks helps lurkers and Google searchers
know that something works. Those different alternatives fit different
layouts and requirements and also demonstrate the logic of rounding
and the logic of Excel's date / Time serial number scheme; not the
easiest of concepts!


--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Wednesday 16th July: Argentina (Independence
Day); Brazil (Sao Paulo State Civil Holiday); Isle of Man (Senior Race
Day); Morocco (King Hassan II’s Birthday); Palau (Constitution Day).
Celebration: Baha’i (Martyrdom of the Bab).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top