Roundup hh:mm:ss date to nearest hr?

  cstirrat 13:12 10 May 10
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 10

Try

=ROUNDUP(A2*24,0)

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

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…