frames to seconds conversion

[shango]

I have a field where users input "frames" as a whole number and I need to have "seconds" calculated automatically.

30 frames = 1 second

The resulting seconds would auto populate another field.

Not sure how to proceed here. Any guidance is appreciated.

Thanks

[LaRetta]

If you have 29 frames, what should the seconds show? If you have 44 frames, what should the seconds show? Do you want fraction seconds or round up or down or truncate?

[shango]

Hi and thanks for responding so quickly!

Here's what I've come up with so far.

Round((shots::frames)/30;2)

However I need to round up to the nearest .5 (half second)

For example:

29 frames rounds up to 1 second

31 frames rounds up to 1.5 seconds

46 frames rounds up to 2 seconds

I'm stumped.

[comment]

Try:

0.5 * Ceiling ( frames / 15 )

[shango]

Well that was it. Never would have thought to look that one up. Thank you very much.

It might be worth at least familiarizing myself with all the built in functions.

[comment]

It might be worth at least familiarizing myself with all the built in functions.

Highly recommended.