CODEWITHSUNDEEP
exceltimeexcel-formularoundingworksheet-function
asimo
asimo

Reputation: 1

Rounding up Date and Time to the nearest hour

I have a column of dates and times. The dates and time column looks like this:

01/01/2013 08:20
01/01/2013 08:55

How do I round up the times from this column to the nearest hour bearing in mind it also has the date in the column?

Upvotes: 0

Views: 767

Answers (2)

userNaN
userNaN

Reputation: 526

As per pnuts' suggestion, I'll post this:

=CEILING(A1,"1:00")

Upvotes: 3

pnuts
pnuts

Reputation: 59450

Please try: 

=INT(ROUNDUP(A1*24,0))/24

if your dates/times are not text.

Upvotes: 2

Related Questions