Can you calculate difference in hours? between NOW and given Datetime?

Oemer Faruk Aslantas

Hello everyone,

i was trying to find to find a way to trigger workflows 2hours later then they should but couldn't find any solution myself.

Assume this is my Created date. Is there a way to calculate the difference between the Created(date) and NOW in Hours? My idea is following:

IF (Created (date) - TimeNOEW) 4 --> start Workflow. So when this number changes to 4, the workflow starts.

Haven't found any function for this. Only found DATEONLY() and TODAY(). But DATEONLY() extracts the Date, not the time.

Thanks in advance for your advice.

Kind regards

Ömer

Sean Morgan

Hello @Oemer Faruk Aslantas ,

You may wish to review the different Time Formulas created by another Smartsheet Member here: https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time/p1

Hyperlinked are Sheet examples of how these are used, and are broken down to understand what each function does.

Let me know if you have any questions!

Regards

Sean

Oemer Faruk Aslantas

Hi Sean,

thx for your response. I already have seen all the files from the link. What I am trying is to run a workflow when a specific date is reached. e.g.

• A new entry has timestamp: 02/02/2021 8:23 PM
• --> I want to run the workflow 4 hours later, so all I want is to compare between the created time and the current time.

So far I had no success with all my attempts..

Kind regards

Ömer