PPRuNe Forums - View Single Post - Can you round up time?

11th January 2005 | 13:05

#3 (permalink)

Llademos

Joined: Dec 2000

Posts: 181

Likes: 0

From: UK

One way of doing it, albeit a bit long winded:

Assuming the original time is in cell A1

Cell B1: =if(minute(A1)>0,Hour(A1)+1,Hour(A1))

A1 gives the time as entered HH:MM, B1 shows the rounded up time as a number