I use a calculated field to calculate the time difference between to colums.
This works but puts out the time in the following format: hh:mm:ss.ssssss
So I tried to change it with Date format to hh:mm but then the calculation doesn't work.
Is there another way to achieve this format?
My calculated field
Code: Select all
SELECT TIMEDIFF(`dtv_test_db`.`stop`,`dtv_test_db`.`start`) FROM `dtv_test_db`
WHERE `dtv_test_db`.`id`='%ID%'
Rogier