Community
Showing results for 
Search instead for 
Do you mean 
Reply

Custom Tables - Time setting and time calculations

Accepted Solution Solved
Nickel Contributor
Posts: 202
Country: Ireland
Accepted Solution

Custom Tables - Time setting and time calculations

I have set up a Time Spent field for Support calls 

1. Can you set default Time to 0 (Zero)? - it is annoying to have to have to keep having to reset Hours and minutes every time I want to log Support call times. IMAGE 1

2. How do you calculate Time - when you have a customer with multiple  support calls - is there a way to calculate how much time sepnd dealing with them? IMAGE 2  


Accepted Solutions
Solution
Accepted by topic author PL98
‎05-29-2018 02:59 AM
Administrator
Posts: 1,379
Country: United_Kingdom

Re: Custom Tables - Time setting and time calculations

[ Edited ]

Hi PL98,

 

Default values are only possible on Character type fields at present.

 

There isn't an easy way to get a sum of values in a column, one way to do this is to export the values to excel and use excel's formula features to calculate the sum. I'd also expect that there are several addons capable of doing this too.

View solution in original post


All Replies
Solution
Accepted by topic author PL98
‎05-29-2018 02:59 AM
Administrator
Posts: 1,379
Country: United_Kingdom

Re: Custom Tables - Time setting and time calculations

[ Edited ]

Hi PL98,

 

Default values are only possible on Character type fields at present.

 

There isn't an easy way to get a sum of values in a column, one way to do this is to export the values to excel and use excel's formula features to calculate the sum. I'd also expect that there are several addons capable of doing this too.