| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| entering numbers to display a time format | Excel Discussion (Misc queries) | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
| Round Time | Excel Worksheet Functions | |||
| time formatting and time categorizing (vlookup or data validation) | Excel Worksheet Functions | |||
| How do I round time? | Excel Worksheet Functions | |||
Linear Mode
