Display amount of time between two time fields?

[SaraHedrick1]

I have two fields, one with a 'Start' time and the other with an 'End' time. Is there a way I can calculate the average time between those two fields and display it in a table? 

I'm still new to insights, and there are a lot of things I want to do, but I'm still figuring out exactly how to do it. 

[LauraBecht · Accepted solution]

Hey Sara,
Right click on the layer in the table of contents, click on data table, add field, name the field, then click to calculate the field and select the start and end time fields to calculate the difference. I think there should be a function you can use. Then you can just add it as a table card.
-Laura

[LLyons]

Hi @LauraBecht , is there a way for this to automatically happen? We'll have new records in the dataset and I'd like to find a way to make this field populate automatically. Thanks!

[LauraBecht]

My understanding is that if your data is in an SDE or other network/cloud database, any changes to it are automatically updated in insights when you open the workbook.  The workbook stores the calculation you made to the table in the workbook, so any new records should automatically be calculated.

If your data is in a local gdb, then you would need a process to add the new gdb to insights, then update the table in the workbook with the new gdb table.

ESRI folks, please correct me if I am wrong.

-Laura

[LLyons]

Appreciate you!