UPDATE reg_att SET Late = case
when time_to_sec(time(LOGIN)) BETWEEN time_to_sec('05:35:00') AND time_to_sec('06:59:00') AND time_to_sec(time(LOGOUT)) BETWEEN time_to_sec('13:35:00') AND time_to_sec('15:35:00')
AND DATE_FORMAT(LOGIN, '%W') IN ('Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday')
then sec_to_time(time_to_sec('08:00:00') - time_to_sec(Rendered))
END;

the output of this is:

Late = 00:03:18

Now, How can be the late become : 00:04:00

Disregard the seconds?

his schedule is 05:35 - 13:35

he login 05:39, so he was late 4 minutes, but in my code it computes 00:03:18 because it regards the seconds.

Any help is highly appreciated.

Thank you so much..

Mandes
—
2012-05-01T19:50:59Z —
#2

If the rest of your code is in PHP, you could just run it through a PHP function