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

Daniel McGovern
Daniel McGovern ✭
edited 12/09/19 in Archived 2016 Posts

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.

Tags:
· Share on FacebookShare on Twitter

Comments

  • 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.

    Peace!

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories