PHP worker hours calculation

Question

So I have the program saving work start and end times into a database like so:

  id    worker_id                  start                     end
1351            7    2013-06-26 08:00:00     2013-06-26 17:00:00

It saves te times for each day separately, and what I need to do is get the working hours for a worker in a period of time set in a form, for example one month.

Any ideas?

possible duplicate of [How to get time difference in minutes in PHP](http://stackoverflow.com/questions/365191/how-to-get-time-difference-in-minutes-in-php) — Baba, Jun 12 '13 at 08:14
I know the time difference part, what i don't get is how to calculate multiple entries simultaniously — user2446928, Jun 12 '13 at 08:20

BlitZ · Accepted Answer · 2013-06-12T08:36:20.430

0

Look at SUM() + TIMESTAMPDIFF() functions:

SELECT
    `worker_id`, SUM(TIMESTAMPDIFF(HOUR, `start`, `end`)) as `total`
FROM
    `table`
WHERE
    (`start` BETWEEN 'period-start-date' AND 'period-end-date')
    AND
    (`end` BETWEEN 'period-start-date' AND 'period-end-date')
GROUP BY
    `worker_id`;

Consider adding WHERE clause with constraining dates.

edited Jun 12 '13 at 08:36

answered Jun 12 '13 at 08:22

BlitZ

12,038
3
49
68

exactly what i needed, great job, thank you CORRUPT! – user2446928 Jun 12 '13 at 08:41

PHP worker hours calculation

1 Answers1