Duration Column Returning Hours Instead of Days. How can I return days?

I’m using this formula to count the number of days since a sales lead was last contacted.

Today()-[Date Last Contact]

The formula is plugged into the [Number Days] Column and is set to duration column type. The [Date Last Contact] column is set to Date column type.

The formula appears to be returning hours. I’m getting a result today (11/5/19) of 433:00:00 with a [Date Last Contact] date of October 18, 2019. 433/ 24 = 18 which would be the number of days since October 18.

What am I doing wrong?

Hours(Today()-[Date Last Contact])/24 gives you the number of days.

1 Like

Thank you @Bellave_Jayaram