View Single Post
 August 4 2013, 03:57 AM #1 JJohnson Captain   Location: Jacksonville, FL Warp speed calculations in Excel I'm working on an Excel spreadsheet that'll calculate the years, days, hours, minutes, and seconds it'll take to travel a given distance in light years. What I have so far only works for warp 1, and I can't seem to find out why it doesn't work for anything higher. So far, I enter a warp speed (TOS scale), it gives me the multiple of light, then m/s, kps, kph. warp: 2 c: =b6^3 m/s: =B7*299792458 (definition of light speed) kps: =B8/1000 kph: =B9*3600 light year: 9460730472580800 meters ly (km): =B12/1000 so, Alpha Centauri is 4.37 ly. time to travel at warp 2: =(F8*\$B\$13)/\$B\$9 or: (4.37*9460730472580.8)/2398339.66 which gives: 17,238,339 seconds That is a little over half a year, with a year being 31,557,600 seconds. now how would I convert that reliably to years, days, hours, minutes, seconds, so that I see: 0 years 150 days 4 hours 8 minutes 10 seconds when I enter a given warp speed? I've got the distance in light years to the closest 20 stars entered, so it'll calculate the time to travel automatically for all those stars, or at least, that's the hope anyhow. If anyone's good with Excel, I'd appreciate any help.