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
ββ
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.
Comments
-
Β
Β
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!
This discussion has been closed.