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.
m/s: =B7*299792458 (definition of light speed)
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
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:
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.