Excel 2007 Formatting Problem
Hope some one can assist
I am constructing a spread sheet where a distance is divided by a speed to get a time taken.
As in A1(distance) / A2 (speed) = A3 (time), but I want the A3 cell displayed as hours and minutes not hours and decimals. I have formatted cell A3 to hh mm and the answer doesn't make sense, as in A1=134 miles divided by A2 9.58mph and the answer appears as 23hrs 41min, not 13hrs 59min.
If I format the A3 cell to "general" the answer is correct as 13.987..., but I want the answer as 13hrs 59min.
I have used the hh mm format on cells where the difference between two dates/ times are taken and displayed successfully as hh mm.
Any help would be appreciated.
Thanks
Merch