Laravel : How to convert time to number of minutes?

Question

In laravel suppose i have input like this '10:30:00' an i want to split them by ":" and covert them into integers and add them like here it will be 10+30=40 will be the output. i used 'explode' to split but i don't know how to add the values.if anyone can help please...thanks.here is my sample code where i am taking time as string.this is not duplicate question as i want to use the exploid function to be used and taking input from user as string. not as time. the question is showing as duplicate of my question is about time only. :)

$startTime= $request->input('starttime');
$finishTime=$request->input('endtime');
$stime = explode(':',$startTime);
$estime = explode(':',$finishTime);

i want to know the way to add them..i will multiply the hour by 60 and add with minutes. i want the output in minutes. — incorporeal, Dec 20 '16 at 05:27
For laravel I prefer to use Carbon as @kapil.dev answer you. It is not good practice to explode the time and add minutes and hours only. Secounds are also useful in some cases. — TIGER, Dec 20 '16 at 05:50

score 4 · Answer 1 · edited Dec 20 '16 at 05:36

4

You can use Carbon to extract Hour and Minute

$startTime= \Carbon::parse($request->input('starttime'));
$stime = ($startTime->hour * 60) + $startTime->minute;
$finishTime=\Carbon::parse($request->input('endtime'));
$estime = ($finishTime->hour * 60) + $finishTime->minute;

To know more about Carbon refer : http://carbon.nesbot.com/docs/#api-interval

edited Dec 20 '16 at 05:36

Rohit shah

833
4
15

answered Dec 20 '16 at 05:33

kapilpatwa93

4,111
2
13
22

score 2 · Accepted Answer · edited Dec 20 '16 at 05:48

2

you can use array_sum($array_name);

Before Performing array_sum You will have to do $stime[0]*60 and $etime[0]*60 so as to convert them into minutes

for $stime do $startsum = array_sum($stime);

and for $etime do $endsum =array_sum($etime);

Hope this Helps You.

edited Dec 20 '16 at 05:48

itzmukeshy7

2,669
1
21
29

answered Dec 20 '16 at 05:26

Rohit shah

833
4
15

if i do this $stime[0]*60 and $etime[0]*60 then how will i pass the value into array_sum()? – incorporeal Dec 20 '16 at 05:39
you will have to store back into $stime[0] = $stime[0]*60 and similarly for $etime[0] = $etime[0]*60 – Rohit shah Dec 20 '16 at 05:40

Hikmat Sijapati · Answer 3 · 2016-12-20T05:49:14.797

1

Did you try like this....

<?php
$time='10:30:00';
$stime = explode(':',$time);


$sum=0;
foreach ($stime as $s)
{
    $sum=$sum+$s;
}
echo $sum;

?>

And if you to use array_sum()..try like this...

$sum=array_sum($stime);
echo $sum;

edited Dec 20 '16 at 05:49

answered Dec 20 '16 at 05:37

Hikmat Sijapati

6,869
1
9
19

yeah by using array_sum() i got the desired output – incorporeal Dec 20 '16 at 05:52

score 0 · Answer 4 · answered Dec 20 '16 at 05:39

You can also use date_parse method for php.

<?php 
$startTime= '10:30:02';
$finishTime= '12:30:20';

$parsed = date_parse($startTime);
$startTimeSeconds = $parsed['hour'] * 3600 + $parsed['minute'] * 60 + $parsed['second'];

$parsed = date_parse($finishTime);
$finishTimeSeconds = $parsed['hour'] * 3600 + $parsed['minute'] * 60 + $parsed['second'];

?>

Laravel : How to convert time to number of minutes?

4 Answers4