I need a result of no more that a 6. So 7 hours 29 minutes should return a 6 and 7 hours and 30 minutes returns a 6. However, a 5 hours and 29 minutes should return 5 and 5 hours and 30 miutes or more returns a 6. So 0-29 minutes rounds down and 30-60 rounds up to the next hour. Im using Excel 2013.

With your target Time in cell A1, try this: =IF(MINUTE(A1)>=29,TIME(HOUR(A1),CEILING(MINUTE(A1),30),0),TIME(HOUR(A1),FLOOR(MINUTE(A1),30),0))

See how that works.

MIKE

I believe that this will meet your requirements: =MIN(TIME(6,,),MROUND(A1,"1:00"))

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

Ask Your Question

Weekly Poll

How long do you think until flying cars or taxis are common?

Discuss in The Lounge

Poll History