Creating a field to add or average time

[srsteiner]

Hi -

Does anyone know how to create a field in a table that will be a period of time (in hh:mm:ss format? A field that can then be added or averaged. I had this problem before, but just used Excel to work around it.

Thanks.

 

[bat17]

Just create a standard date field and format as hh:nn:ss. the only problem is that it wont show a result over 24 hours so if you need larger values you will either have to use days as well or create a custom funtion to display it.
HTH

Peter

PS. Welcome to the board!