Excel - Time display

[Guest]

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

 

[Trevor Shuttleworth]

Try:

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

Regards

Trevor

 

[Guest]

=text(c2/70/24,"[h]:mm") combines the calculation of distance over speed with
the conversion from decimal hours to a display of time.

 

[Guest]

Thanks very much to both - I almost had it myself, just couldn't get it
right. You have been a big help.
--
Regards
rbc

Try:

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

Regards

Trevor

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

 

[Guest]

Thanks to both - everything works fine now.
--
Regards
rbc

Try:

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

Regards

Trevor

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