Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

how to change the duration from days to hours


i have several sheets that i combine into one master sheet. the problem is when i link a cell that has hours in it, it translates that to days and is throwing off the calculation. how can i change the duration column so that it represents hours and not days.


  • Heidi Decker
    Heidi Decker ✭✭✭✭✭✭



    Hi Daniel,

    Maybe you should contact support@smartsheet.com. I have several linked cells that hold the duration and many of mine are in hours not days. Mine keeps the hour format even with the linking. I even played with it for a few minutes and it always kept the exact information of the cell it was coming from. Hope you find an answer.


This discussion has been closed.