# How to calculating the age of a cell in hours

edited 10/26/21

Background -

I have a Form, which outputs as a row in a Grid, an extract of which is as follows -

The 'Date Raised' column contains a System-generated - Create (Date) value, and the 'Current Date/Time' column contains today's date (using the =TODAY() function).

Problem -

I am trying to find a formula-driven solution, which will populate the 'Task Age (hrs)' column with the difference in hrs between the value in ''Date Raised' and 'Current Date/Time' i.e. time elapsed in hrs.

The purpose of this is to track if a Task has been completed on time e.g. High Priority (4 biz hrs), Medium Priority (8 biz hrs), and Low Priority (24 biz hrs).

As I see it, I have the following obstacles to overcome -

• Current Date/Time column - Is there a formula (e.g. something that can expand =TODAY()) that will populate the date and time in the same format as the 'Date Raised'' column?
• Task Age column - if the above is possible, how then would I compute the difference (in hrs) between the 'Date Raised' and ''Current Date/Time' column.

Thank you in advance, for any assistance anyone can offer.

Tags:

• ✭✭✭✭✭✭

Hi @wtcf

Hope you are fine, Unfortunately, this feature is not currently available. it's a good idea and you can submit Smartsheet Product Enhancement Requests using this form.

PMP Certified

[email protected]

www.mobilproject.it

• ✭✭✭✭✭✭

Hi @wtcf

I hope you're well and safe!

Please have a look at my post below with a method I developed that probably could be modified to work for your use case.

Would that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• edited 10/28/21

Hi @Andrée Starå - thanks for your response. Unfortunately, I haven't been able to understand your post, especially, it would be great for more context, and how I can apply the outlined principles to my use case?

• ✭✭✭✭✭✭

Hi @wtcf

I hope you're well and safe!

How did it go? Did you manage to get something set up?

I hope that helps!

Have a fantastic weekend & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!