How to calculate time worked: Start time, end time, lunch break

[khalinguyen191999]

I have a sheet which has the start, stop and time taken for lunch breaks.

I want to calculate the total time worked such that i have the hours worked. So if i worked 7 hours and 30min then the total time would be 7.5hrs. But i am not sure how to take into account the lunch break time (see enclosed sheet).

anyone have any ideas?

[bebo021999]

no attachment found.

Clck vào advance, cuộn con trỏ xuống, click vào Manage attachment rồi đính kèm file nhé bạn.