¿How to calculate the time with current date/hour?

[#1]

Hi there,

I have a problem with calculation time.

I have a field with Date and Time, and i need calculate how many time is running from now to Created Date:

ID	Created	Now
799	25/04/2016 10:30:00 AM	25/04/2016 11:07
798	25/04/2016 10:15:00 AM	25/04/2016 11:07
797	25/04/2016 10:11:00 AM	25/04/2016 11:07
796	25/04/2016 09:44:00 AM	25/04/2016 11:07
795	25/04/2016 09:23:00 AM	25/04/2016 11:07
794	25/04/2016 09:05:00 AM	25/04/2016 11:07
793	25/04/2016 08:11:00 AM	25/04/2016 11:07
792	25/04/2016 07:53:00 AM	25/04/2016 11:07
791	25/04/2016 07:31:00 AM	25/04/2016 11:07

For example, in the ID 799 the time should be 00:37:00. (Now-Created)

I dont know how to create Now function (Date+hour)

Best regards.

[sunny_talwar · Accepted solution]

May be try this:

Interval(Now() - Created, 'hh:mm:ss')

UPDATE: Now() function includes date and time.

[#3]

Hi Sunny T,

The Now() function has date (25/04/2016) ?

Thanks for your response.

[sunny_talwar]

Try =TimeStamp(Now()) and it should display you the time component as well.

[#5]

Thanks! It is working!