Try:

=SUM(C2/70)/24 formatted as [hh]:mm

Regards

Trevor


"rbc" wrote in message
...
I am using the following formula to calculate the time to travel a given
distance at a given speed: =sum (c2/70) where c2 is the distance and 70
is
the speed.
The result I get gives me the time in hours only e.g. 1.50 which is 1hr
30mins.
I can display this in hrs and mins in another column by using
=TEXT(F2/24,"[h]:mm")
However can I "add to" or "combine with" the original formula "Dist/Speed"
to get the result to display in hours and minutes in one column; withour
having to using another column & formula to do so.
Currently I am putting the distance in one column and then displaying the
time in another column using "dist/speed". I am not putting the speed in
a
column.
Thanks for any help
rbc
--
Regards
rbc