| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need excel formula to display 28.50hrs in HRS & MINS?
I am trying to calculate distance, speed and time to cover the distance in
Excel spreadsheet. I am using distance/speed to display the time in hours & decimals of an hour, e.g. 28.50hrs [which is 28 hrs 30mins]; but can't come up with a consistent formula to display the time in hours and mins. =TEXT (F2/24 etc.) does not work once the number of hours is more than 24hrs. Can anyone suggest a formula please? -- Regards rbc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel: To Display Formula in the cells Instead of Value | Excel Discussion (Misc queries) | |||
| Paste is is copying in formula, but display is wrong. | Excel Worksheet Functions | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
| Display excel formula on worksheet | Excel Worksheet Functions | |||
Threaded Mode
