Hello everyone.
Some time ago, I made an Excel (also works with Google Drive) spreadsheet that transforms frame numbers into minutes, seconds and centiseconds, given the FPS of the game. I tested the accuracy of this using some submissions of TASVideos and it gave the same result as the submission.
It makes the work of doing weird maths to get an accurate time very easier, so it's very useful for me.
You can download the file
here.
If it doesn't work, create a Google Drive (or Excel) spreadsheet and paste the following in B3:
=IF(B1<((B2*B2)-1);"";(ROUNDDOWN(B1/B2/B2;0))&"'")&(ROUNDDOWN(ROUND((B1/B2/B2-ROUNDDOWN(B1/B2/B2;0))*B2;2);0))&"''"&IF(ROUND((ROUND((B1/B2/B2-ROUNDDOWN(B1/B2/B2;0))*B2;2)-ROUNDDOWN(ROUND((B1/B2/B2-ROUNDDOWN(B1/B2/B2;0))*B2;2);0))*100;0)<10;"0"&ROUND((ROUND((B1/B2/B2-ROUNDDOWN(B1/B2/B2;0))*B2;2)-ROUNDDOWN(ROUND((B1/B2/B2-ROUNDDOWN(B1/B2/B2;0))*B2;2);0))*100;0);ROUND((ROUND((B1/B2/B2-ROUNDDOWN(B1/B2/B2;0))*B2;2)-ROUNDDOWN(ROUND((B1/B2/B2-ROUNDDOWN(B1/B2/B2;0))*B2;2);0))*100;0))
After doing it, put the frame number in B1 and the FPS in B2.
I hope it gets useful for someone! :D
