Formula to convert seconds into hours+minutes format?

DigiChainDigiChain Member, PRO Posts: 1,277
edited May 2016 in Working with GS (Mac)

Hi, this isn't a strong point of mine and I'm sure some of you maths gurus will be rolling your eyes - but i'm trying to create a simple formula to convert seconds into hours+minutes.

So for example I have 4800 seconds.
I'm after a formula to convert this to hours+minutes (and in this case get the result 1hr 20mins).

Any help appreciated! Thanks

Comments

  • birdboybirdboy Member Posts: 284
    edited May 2016

    Hey @DigiChain

    made a very quick demo, hope this helps.
    The seconds attribute is inside the actor.

  • DigiChainDigiChain Member, PRO Posts: 1,277

    @Hoodloc - great thanks!
    The formula is actually showing 120 secs as 2hrs 0mins... but I think I can make sense of this now and sort it out.

    Cheers!

  • birdboybirdboy Member Posts: 284
    edited May 2016

    Hah brainfart. :disappointed:
    I changed the demo file to show correct values. ;)

    Edit: Editing the first post doesn't work for whatever reason. I'll attach it in a new post.

  • birdboybirdboy Member Posts: 284
    edited May 2016

    Ignore this post. This one isn't working. The correct file is "imStupid".

  • birdboybirdboy Member Posts: 284

    Now, here we go. This is the correct one...

  • DigiChainDigiChain Member, PRO Posts: 1,277

    Ha ha - awesome, works a treat.
    Thanks Hoodloc!

Sign In or Register to comment.