calculation of work time and lunch time of individual days - php/mysql
<p>example: </p>

<p>if a user come office in morning, go to lunch, come office after lunch, and then go to home then how we can calculate work time and lunch time</p>

<p>[ currently i have 'start time', 'end time' and total time including lunch time ]</p>

<p>I need 'total time' excluding 'lunch time' order by individual dates</p>

<p>Please help me!   </p>
