View Single Post
  #4   Report Post  
 
Posts: n/a
Default Footage to seconds (# to mm:ss).

Two steps to think about
first convert feet into seconds
then convert number of seconds into a time as understood by Excel

Your conversion factor of 1.66666... would be better thought of as 5/3
so feet*3/5 = seconds

next the time bit. If you format a cell as date or time, Excel treats 1as
a day which is 24 hours or 1440 min (24*60) or 86400 sec (24*60*60)
so seconds/24/60/60 formatted as time will display correctly
however because you want mm:ss custom format as [mm]:ss
the [ ] allow the mm to go above 59 without showing hours

If you do want hours [hh]:mm:ss

In full if feet value is in A1
formula is =A1*3/5/24/60/60
Custom formated [mm]:ss

hth RES