JoeMNY

Posts: n/a

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
entering numbers to display a time format	Ian Williams/Eazygig	Excel Discussion (Misc queries)	1	January 10th 05 11:57 AM
Help - Information with time and date	PM	Excel Discussion (Misc queries)	4	January 6th 05 08:25 AM
Round Time	cpme	Excel Worksheet Functions	2	November 18th 04 07:09 PM
time formatting and time categorizing (vlookup or data validation)	MarianneR	Excel Worksheet Functions	4	November 18th 04 03:24 PM
How do I round time?	cpme	Excel Worksheet Functions	3	November 17th 04 12:37 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us