How much time between two time fields should be displayed?

[jamesbondss]

Hello, i am James from Chicago and a business owner of a tech company.
One of my fields has a "Start" time, and the other has an "End" time. Is there a way to generate a table that shows the average time between those two fields?

I'm still learning how to use insights, so there are many things I want to do but don't yet know how to do them.

[JenniferAcunto]

If you click on the the three dots next to your data source name and open up the data table you can calculate a new field that shows the length of time between two dates. 

The calculation you would use is DATEDIF(start_date, end_date, [unit]). The Unit is the unit of measurement you want to calculate:

• "ss" = seconds
• "mm" = minutes
• "h" = hours
• "D" = days
• "M" = months
• "Y" = years

Once this new field has been calculated, you can use it like any other numeric field in Insights to display the average length of time. 

Calculate a field in the data table

Functions