|
|
|
|
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.
|