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