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

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?