How to calculate time in speed-distance-time calculations and express it in hours:minutes. I am converting from Excel to Numbers. In Excel I can calculate time by dividing speed into distance using the formula "Distance/Speed/24" and formatting the a
I am trying to switch from Excel to Numbers. In Excel I prepare travel sheet depicting Distance, Speed, and the resulting Time expresses as hours:minutes. I do this by entering 100 in cell A1 (distance) , 40 in cell B1 (speed), and "=A1/B1/24" in cell C1 (which has been formatted as Time (H:M). Is there a way to make this calculation expressed as H:M in Numbers? I am using MacBook Pro running Yosemite.
MacBook Pro (Retina, 15-inch, Mid 2015), OS X Yosemite (10.10.5)
