Timestamp

Chris G

Chris G ✭✭

08/24/23 in Formulas and Functions

Hi Team,

I have looked on here with no luck so far. I may be using the wrong search terms.

I want to subtract one timestamp from another to get the hours worked on-site for the day.

Is this possible?

Thank you

Chris

0 ·

Answers

Shubham ✭✭✭✭

08/25/23

Hi Chris G,
It would be great if you could provide some more details, like column time and screenshots for a better understanding.
Thanks,

0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Row with Multiple drop down choices and creating a summary
We have a Column on our Sheet which is a drop down list however more than one can be picked? Is there a way to as a summary to look for that field so that it sums it up? Below are 2 which are in a row and chosen from the drop down When we do the summary we would like this to be counted in both the IT Operations and Infra…
Next Expense Date Formula
I need to create a formula that will find the next expense date based off 3 other column categories. The columns and their categories are as follows: Due Date (single date when expense is due), Program ( Men, Women), and Budget Impact (Income, Expense). For this formula I need to find and return the next expense date from…
Automation Question around running on a Date field
I'm working on doing some cleanup on a smartsheet that had some extra columns/automation that I don't believe are in use. I have a question around how an automation uses dates, so i'll give what is probably unneccesary background. :-) For example, in our smartsheet there is a date field called CST Due for Info Update -…