0

Calculate Minutes to hours

Hi everyone ! I work in cinema business and want to create a formula to convert minutes to hours.  I tried many times but it wasn't a success. I want to keep both informations : a case with minutes and a case with hours (which will be calculated by Ninox with the minutes informations). How can I do this ?

 

Thanks you in advance.

5 replies

null
    • Mconneen
    • 4 yrs ago
    • Reported - view

    @Angie

    So..if something is 72 minutes in duration .. do you want to know it is 1.2 hours (72/60) ... or do you want to know it is 1 hour and 12 minutes   1 : (72-60) ?? 

    • Mconneen
    • 4 yrs ago
    • Reported - view

    Sorry.. hit post and forgot to upload image. :( 

    time

    • angie
    • 4 yrs ago
    • Reported - view

    Hi ! Thanks ! Yes I want to find a formula like : 90 minutes = 1 hour and 30 minutes ; 120 minutes = 2 hours, 140 minutes = 2 hours 20 minutes

    I try something like your image but it did'nt work...

    • Mconneen
    • 4 yrs ago
    • Reported - view

    @angie

    What did not work?   Use the timeinterval function .. 

    • angie
    • 4 yrs ago
    • Reported - view

    Now it's work thanks ! I retried a few times : Ninox gived me with the timeinterval function for 180 minutes = 1080000 hours and not 3 hours. I don't understand why Ninox gived me this results. Now it's okay I get 3 hours for 180 minutes with the same formula. Thanks you very much !

Login to reply

Content aside

  • 4 yrs agoLast active
  • 5Replies
  • 845Views