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

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

HomePod review

Streaming : Netflix ou Amazon Prime Video ?