添加时间类型栏

Question

不知道怎么加时间

工作控制器

if($request->status === 'completed')

    {

        $t = 0;

        $alltime = Work::where('project_id', $project->id)->get();

        foreach($alltime as $time)

        {

            $t = $t + $time->work_time;

        }

        $project -> fill(['total_work_time' => $t])->save();

    }

但是没有一个好的方法可以做到这一点吗？

Answer 1

你可以用区间求和，$base_time = new DateTime();$time_now = clone $base_time;foreach ($alltime as $time) {    $array = explode(':', $time);    $base_time->add(new DateInterval(sprintf('PT%dH%dM', $array[0], $array[1])));}$sum_of_diff = $time_now->diff($base_time);