I have a query that creates a table and every day adds the previous days data to it. In the attached you see total dials and talktime columns and then April 1 Dials and TT. Each day this table will get created with the next days date.
The issue I am having is the TT column is a decimal number as seen in the attached but I need it to be displayed as h:mm:ss.
Is there a way to update the format of every TT field to h:mm:ss as it gets added each day?