To get your fraction, just do a mod 1 of the large multiplied number above (I think the syntax would be "=mod(time * 86400, 1). If you want excel to represent that back as hours:minutes:seconds, just divide by that large number again. Or, since you're probably in excel, where 1 day = 1, you'll need to multiply up by 24 hours * 60 minutes * 60 seconds (86400) to scale the seconds up to whole numbers, THEN take the floor to get the even number of seconds. Try storing it in two columns using the mod, divide, and floor operators? Divide by "1 second" to trim off the centi-seconds, and take the floor to get to an even number of seconds. The math is easy (.96*30=28.8 frames) but converting those values in a spreadsheet would be more complicated than I want.įor OpenOffice Calc you format a cell value for minutes, seconds, 1/100 second as: M:SS.00. I was hoping to just format the numbers in the cell but I don't think it'll be that easy.
I might be totally mis-interpreting what you want.What I basically need to do is convert 1:22.96 (one minute, 22 seconds, 96 one-hundreths of a second) to 1:22.29 (one minute, 22 seconds, and 29 frames). If you could clarify the problem a little more, it would be helpful. So, to get numbers of milliseconds from a time entered as hh:mm:you would divide by this number. An actual ms would therefore be 1.16E-08.
so entering 0:00:01 (one second) would yield 1.16E-05 as a number. I might be totally mis-interpreting what you want.Īs for the actual time units, if you enter something as a time, excel represents it as a fraction of a day. With the period, you can keep adding to the time to get the proper value you want at each space. if you're going from beats per minute to the time you're actually going from frequency to period, in which case you would still invert Gotta love that math. Your descriptions sound contradictory though. As mentioned above, be sure to convert your milliseconds to seconds by dividing by 1000 before inverting or multiplying after. Or, if you want, you can invert first then multiply. If your samples don't correspond to frame boundaries, you'll need to add up as many as you need to get an even number of frames, THEN divide by the number of frames you got and invert. Of course, if you just enter the number of milleseconds to begin with and ignore Excel's fun handling of dates and times, you should be able to get the frame rate by inversion.
OPENOFFICE CALCULATE HOUR MINUTES FULL
Here's the full number, as far as excel represents it: 1.157407407407410E-08 Of course, DON'T FORGET TO DIVIDE by 1000! Otherwise, you'll be getting frames per millisecond, which will be very small indeed.Īs for the actual time units, if you enter something as a time, excel represents it as a fraction of a day. Assuming the millseconds are seconds-per-frame, wouldn't you just need to say fps = 1/spf? If you have lots of different samples, just average them or something.
0 kommentar(er)
