Hello.
I have used (SELECT TIMEDIFF(TIME1,TIME2)) AS TIME, in my sql statement.
I now need to convert this time to seconds, so if the value in TIME = 1:30:10 I need to display 5410 in seconds?
I can then multiply this by 1.5 to give me 8115 seconds and then divide it by 60 and 60 again to give me 2.25 which will be amount paid at overtime?
Thanks
Paul