Hallelujah, I found the answer! thanks June7 for putting me on the right path
Code:
SELECT sl1.staff_log_date, sl1.staff_log_empl_num, (DATEDIFF("s",sl1.staff_log_time, sl2.staff_log_time)/60.00)/60 as tester, *
FROM staff_login sl1 INNER JOIN staff_login sl2
ON sl1.staff_log_empl_num = sl2.staff_log_empl_num
AND sl1.staff_log_date = sl2.staff_log_date
WHERE sl1.time_in_time_out = 'IN' and sl2.time_in_time_out = 'OUT';
I abandoned the idea of restructuring the table. I joined the table to itself then used the datediff function to get the hours