Round Time

G

Guest

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

Puzzled by simple MPH calculation? 1
COMPARING TIMES AND DISPLAYING TEXT USING IF CONDITION 3
Conditional Time Calculation 10
Round to the nearest minute if more than 6 seconds 2
time calculation 7
Baffeling IF statement 7
How do I calc the time difference in hh:mm for shift work? 10
Need to work out a timesheet with times going into next day (>24 h 5

Top