Round Time

J

JoeMNY

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Time Calculation 10
Help needed regarding calculating time 0
COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
Round to the nearest minute if more than 6 seconds 2
problem with time subtraction 7
setting cell values based on a 3rd cell 4
Need Help 4
Over time? 4

Top