dilfdo
3 years ago
81
14
Laravel

calculating total hours from times laravel sql

Posted 3 years ago by dilfdo

how to calculate total hours from number of rows using laravel

time_sheet_id     shift_start_time     shift_end_time

35                  08:00:00            10:00:00

35                  10:00:00            13:00:00

35                  13:00:00            15:00:00

36                  13:00:00            15:00:00

36                  13:00:00            15:00:00


36                  13:00:00            15:00:00


i want to calculate no of hours for each timesheet_id . pls advice

Please sign in or create an account to participate in this conversation.