Roundup hh:mm:ss date to nearest hr?

  cstirrat 13:12 10 May 2010
Locked

Hi,
I'm trying to round up a long list of times to the nearest hr in an Excel column but it doesn't always seem to round up to the nearest hr, e.g.
11:51:04 12
14:29:28 14
22:54:39 23
10:42:01 10
21:44:36 21
11:27:12 11
10:40:32 10

A couple of these are innacurate.
I typed in =roundup(cell ref, 2)
Anyone know how to resolve this please?
Many thanks,

  VoG II 13:17 10 May 2010

Try

=ROUNDUP(A2*24,0)

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iPhone X review

Political cartoons in 2017: Chris Riddell, Rebecca Hendin and Dave Brown on what it’s like to…

The best iPhone for 2017

Tennis : comment regarder la finale de la Coupe Davis 2017 ?