Sum of time column
Posted: 2021-02-02 13:44
Hi.
I want to suggest the availability to sum time as total of a column as I can do with decimal values.
I have made an application for worksheets where I put the works I do to my customers, the time employeed and the kilometers I made to do that work. I can sum the total of kilometers (it is decimal field) but not the time. I think it will be very helpful becaus I can apply a filter and get the total amount of time.
As example there is this image with a filter applied (customer and date >= 01/01/2021 and date <= 31/01/2121):
Into this, I have technical actuations where I write the every thing I do and the time and kilometers and with a select I can sum the total of work for a day for a customer:
SELECT TIME_FORMAT(SEC_TO_TIME( SUM( TIME_TO_SEC(`tiempo`) ) ), '%H:%i') from parteactuacion WHERE `parte`='%ID%'
and that is what you see in the picture before.
Please, do you think this will be possible in the future?
Thanks a lot.
I want to suggest the availability to sum time as total of a column as I can do with decimal values.
I have made an application for worksheets where I put the works I do to my customers, the time employeed and the kilometers I made to do that work. I can sum the total of kilometers (it is decimal field) but not the time. I think it will be very helpful becaus I can apply a filter and get the total amount of time.
As example there is this image with a filter applied (customer and date >= 01/01/2021 and date <= 31/01/2121):
Into this, I have technical actuations where I write the every thing I do and the time and kilometers and with a select I can sum the total of work for a day for a customer:
SELECT TIME_FORMAT(SEC_TO_TIME( SUM( TIME_TO_SEC(`tiempo`) ) ), '%H:%i') from parteactuacion WHERE `parte`='%ID%'
and that is what you see in the picture before.
Please, do you think this will be possible in the future?
Thanks a lot.