Good afternoon,
I have created a query that calculates time, but it doesnt appear correct I think.
In my source table ([time]) I am calculating the time spent that has been registered for jobs completed in a day, which seems to work but my times calculated together show as "5.71759259259259E-03".
How would I get the query to show these as 00:00:00 for the day?
thanks in advance
I have created a query that calculates time, but it doesnt appear correct I think.
In my source table ([time]) I am calculating the time spent that has been registered for jobs completed in a day, which seems to work but my times calculated together show as "5.71759259259259E-03".
How would I get the query to show these as 00:00:00 for the day?
thanks in advance