CODE EXAMPLE FOR SQL

hour differeence in mysql

SELECT TIMESTAMPDIFF(HOUR, start_time, end_time) 
           as `difference` FROM timeattendance WHERE timeattendance_id = '1484'