tusa
Member
Hello.
I have a calc field whree I calculate hours.
I usw a select command:
It calculate the hours between 2 date/time field.
How can I calculate across 2 different dates?
If I do that right now I only get a - before and the wrong amount of hours.
brg Tue.
I have a calc field whree I calculate hours.
I usw a select command:
Code:
SELECT TIME_FORMAT(SEC_TO_TIME(TIME_TO_SEC('{fab_timeregistrering___slut}') - TIME_TO_SEC('{fab_timeregistrering___start}')), '%H:%i')
How can I calculate across 2 different dates?
If I do that right now I only get a - before and the wrong amount of hours.
brg Tue.