Subtract minutes from Hours

Options
Frank S.
Frank S. ✭✭✭✭✭✭
edited 07/27/21 in Formulas and Functions

Greetings,

I'm trying to subtract minutes from a set number of hours and display the amount of time left in HH:SS.

For Example:

There are 10 hours available for testing but totally the environment came up 35 minutes late.

I know it is something simple but I'm missing it.

Frank Smith, PMP

Assistant Director | IT Special Projects Mgr.

Oregon Parks & Recreation Department

If my response helps, please mark it as an accepted answer. 😎

Tags:

Answers

  • Frank S.
    Frank S. ✭✭✭✭✭✭
    Options

    Another question, related:

    How to convert a decimal time into HH:MM?

    Frank Smith, PMP

    Assistant Director | IT Special Projects Mgr.

    Oregon Parks & Recreation Department

    If my response helps, please mark it as an accepted answer. 😎

  • Bassam Khalil
    Bassam Khalil ✭✭✭✭✭✭
    Options

    Hi @Frank.Smith 

    Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

    PMP Certified

    bassam.khalil2009@gmail.com

    ☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!