Rounding time

[Christian Davidsson]

Hello,

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

Thanks in advance,
Christian Davidsson

 

[Harlan Grove]

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

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

=ROUND(SomeTime*24,0)/24

 

[Christian Davidsson]

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

 

[Norman Harker]

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.