How to calculate break hours from in/out details in php?

[hemal8888]

Hello All,

i want to need Idea about how to calculate break hours from in/out details


In My Database Design is:

ID EmpEntryDate EmpInTime EmpOutTime Empid
1 2014-09-22 10:28 13:21 209
2 2014-09-22 14:04 18:27 209


Break Hours : 0.47

In Below CODE i just given total sum No break Hours

SELECT `EmpEntryDate` , TIME_FORMAT( SEC_TO_TIME( SUM( TIMEDIFF( `EmpOutTime` , `EmpInTime` ) ) ) , "%h:%i" ) AS TOTAL_SEC
FROM attemppresentdetail
WHERE `Empid` = '209'
AND `EmpEntryDate` = '2014-09-22'
LIMIT 0 , 30
 

TOTAL_SEC : 06:46

Thanks

[Rabbit]

Join the table to itself so you can join one record to the next. That will give you the current record's out time and the next record's in time, allowing you to calculate the difference between the two.

[hemal8888]

Hello Rabbit,

Thanks For reply ,

can you please show me any example or demo so i can understand easily.