I am barely new to Smartsheet but I can see the potential of helping me with my job duties,
I work as a service dispatcher, We have been running out of Microsoft spreadsheets but I don't know a lot of coding and VBA so if I figured out how to obtain the average time in when the tech arrives on-site versus the time back to work(job complete), the average response time its being obtained from the time we got a service call in minus the time arrived on site. (I added to he formula *24 to convert days to hours but did not work)
so far I got days in, but no hours and I need this for my weekly report.
Does anyone know a possible solution for this problem?