divide PHP time (h:i)

Question

I have an employee timesheet where durations are divided by the number of days an employee works.

E.g 25:00 over 3 days = 25:00/3=08:20

I have tried the simple divide query above, however this does not show a result. Is it possible to divide a h:m string?

split on `:`, convert to integer, convert hours to minutes, add remaining minutes, divide by three, reconvert to `hour:minutes` — Federico klez Culloca, May 08 '18 at 10:48
Possible duplicate of [Divide HH:mm:ss string data with integer value](https://stackoverflow.com/questions/32239524/divide-hhmmss-string-data-with-integer-value) — iainn, May 08 '18 at 10:49
convert in to minute and device by 3 then again convert in to hour: minute format. it's simple. — Vipul Solanki, May 08 '18 at 10:51
Possible duplicate https://stackoverflow.com/questions/8563535/convert-number-of-minutes-into-hours-minutes-using-php — 4EACH, May 08 '18 at 11:07

ThomasVdBerge · Accepted Answer · 2018-05-08T10:58:42.337

4

Best approach would be to convert to seconds and use date to display it.

$time ="25:00";
$days = 3;

list($hours, $minutes) = explode(":", $time);
$minutes += $hours*60;
$seconds = $minutes*60;
date_default_timezone_set ("UTC");
echo "new time: " . date("h:i", $seconds/$days);

See the result here

edited May 08 '18 at 10:58

answered May 08 '18 at 10:51

ThomasVdBerge

6,316
3
39
58

divide PHP time (h:i)

1 Answers1