Working with Time

[Slacker77]

Does anyone know how to create a formula where you can obtain the difference in hours between two times and then use that value in another formula.

e.g. 11am to 7pm = 8hours

80 miles / 8hours = 10 (miles/hour)

There is no problem obtaining and displaying the number of hours. However the number behind is a decimal, which can't be used elsewhere.

Any ideas?

[Slacker77]

Just worked it out. You stick a x 24 at the end of the formula, to get a hard value in hours.