Ref TimeStamp to find difference between 2 times


I'm making a Log IN & OUT application.

I've created this application in Google Sheets / Forms but I'd like to create the same in SS.


User fills out form; selects "IN" or "OUT" along with company name and person name

(Created Data column acts as Timestamp)


When I reference the Created Dates to format in a understandable column display in-which Time IN and Time OUT reference the Created Date I can NOT subtract IN from OUT:

To reference the Created Date column titled Timestamp I use =TimeStamp@row + ""

But it seems that SS doesn't see this as a unit only a value which can not be used in a calculation.

Is there anyway around this???

Thanks for any help with this


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!