ExcelBanter - Round Time

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Round Time (https://www.excelbanter.com/excel-worksheet-functions/6664-round-time.html)

JoeMNY

Round Time

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.

cpme

Outstanding, Frank! Thanks alot!!!

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

All times are GMT +1. The time now is 01:03 PM.