I'm sorry, I don't have an answer for you but I too have been trying to round
time using "h:mm." I'm trying to round the time to the nearest quarter hour
and I found it almost impossible. I know that by using the MROUND function
you can round specific numbers to any interval you want. But when you're
dealing with different times it's impossible to use this method. I hope
someone can help us out!

"JoeMNY" wrote:

Greetings:

I have a distance speed formula that returns time to travel.
A1=120 miles
B1=91 MPH
C1=A1/B1/24=1:18:56

I would like C1 to display only in h:mm rounded to the nearest minute. Next
I have
D1=13:00 (start time)

I want E1 to display the arrival time in h:mm rounded to the nearest minute.

TIA for your help.

Thanks Frank. It worked as advertised.


"Frank Kabel" wrote:

Hi
see:
http://www.xldynamic.com/source/xld.Rounding.html#time

"JoeMNY" wrote:

Greetings:

I have a distance speed formula that returns time to travel.
A1=120 miles
B1=91 MPH
C1=A1/B1/24=1:18:56

I would like C1 to display only in h:mm rounded to the nearest minute. Next
I have
D1=13:00 (start time)

I want E1 to display the arrival time in h:mm rounded to the nearest minute.

TIA for your help.

Hi
see:
http://www.xldynamic.com/source/xld.Rounding.html#time

"JoeMNY" wrote:

Greetings:

I have a distance speed formula that returns time to travel.
A1=120 miles
B1=91 MPH
C1=A1/B1/24=1:18:56

I would like C1 to display only in h:mm rounded to the nearest minute. Next
I have
D1=13:00 (start time)

I want E1 to display the arrival time in h:mm rounded to the nearest minute.

TIA for your help.