How to round up my given time is to thest last 15 minutes?

Question

I am working with OT management system. I am calculating some OT value related to the each employee.now i want round up this OT value in last 15 min. How do i do it? Example values are given below.

07:17:46 need to be 07:15:00
06:25:25 need to be 06:15:00

Similar question: Round minute down to nearest quarter hour

`round up` -> `07:17:46` would actually be 8:15 - I believe you want to round down — treyBake, Sep 19 '19 at 10:15
No need to reopen on a slight extension on the seconds. Not every snowflake needs to be saved -- especially when no effort is shown. https://3v4l.org/Bqi4t this is just one random answer from the other page that works just fine. I have voted to delete. — mickmackusa, Sep 19 '19 at 10:50

Janie · Answer 1 · 2019-09-19T10:32:08.323

1

Create your own function to round/floor the value. You can explode the time, then subtract the reminder to make it rounded. Example:

function _floor($time) {
    $elm = explode(':', $time);
    $elm[1] -= $elm[1] % 15;
    $elm[2] = '00';
    return implode(':', $elm);
}

echo _floor('07:17:46') . PHP_EOL;
echo _floor('06:25:25') . PHP_EOL;

Demo at https://3v4l.org/LBKDp

edited Sep 19 '19 at 10:32

answered Sep 19 '19 at 10:23

Janie

638
9
26

This version rounds the seconds instead of the minutes. My edit fixed that but was rejected ... – Flunch Sep 19 '19 at 10:29
not working bro .it will print 07:17:46 as it"s not 07:15:00 – Code Kris Sep 19 '19 at 10:31
Updated the answer. Please check it now. – Janie Sep 19 '19 at 10:32

Blackbam · Accepted Answer · 2019-09-19T11:30:59.820

0

Split into hours, minutes and seconds. Round the minutes down, fill with zeros and return.

function timeLastQuarter($timestr) {
  $time = explode(":",$timestr);
  return str_pad($time[0],2,"0",STR_PAD_LEFT).":".str_pad(((floor($time[1] / 15))*15),2,"0",STR_PAD_LEFT).":00";
}

Example:

echo timeLastQuarter("15:55:00"); // 15:45:00

edited Sep 19 '19 at 11:30

answered Sep 19 '19 at 10:38

Blackbam

17,496
26
97
150

it working separately but in case it print nothing .i try to print as '$table .='' . timePreviousQuarter($holifinalOT01) . '';' – Code Kris Sep 19 '19 at 11:05
but it is not print nothing without timeLastQuarter its work .what is problem – Code Kris Sep 19 '19 at 11:06
$holifinalOT01 which hold the ot value – Code Kris Sep 19 '19 at 11:06
Seems like to have to learn PHP basics. Of course you have to print / echo the output and furthermore make sure that the input is a correct time string. If it is not working you have to debug whats wrong, the function itself is correct. – Blackbam Sep 19 '19 at 11:06
no no finnaly table will be print. – Code Kris Sep 19 '19 at 11:08
1

$table .='' . $holifinalOT01 . ' is printed correct value – Code Kris Sep 19 '19 at 11:10
Cool. Then you may accept the answer in order to close the question – Blackbam Sep 19 '19 at 11:23
but round up function value is not print bro – Code Kris Sep 19 '19 at 11:27
Changed from echo to ŕeturn, just a little thing to notice. Copy the new function. – Blackbam Sep 19 '19 at 11:31
1

thank you bro .much appreciate beginner for legend help – Code Kris Sep 19 '19 at 11:37

How to round up my given time is to thest last 15 minutes?

2 Answers2