SOLVED

New Contributor

# Formula for Timesheets using IF THEN Scenario

I would like to create a formula in timesheets which calculates the total hours worked less the break time taken and if the "Break" column is No then the total hours will be from start time to finish time. Please see example below.

4 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

# Re: Formula for Timesheets using IF THEN Scenario

It could be

``=D3-C3 - IF( E3 = "No", 0, E3)``

# Re: Formula for Timesheets using IF THEN Scenario

Thanks @Sergei Baklan that has worked.

# Re: Formula for Timesheets using IF THEN Scenario

@sherryn , glad it helped

# Re: Formula for Timesheets using IF THEN Scenario

Any help for this?

 DATE WORKING HOURS HOURS START TIME ON SITE OFF SITE FINISH TIME STD HOURS x1.5 x2 TOTAL 14/02/2022 07:40 09:00 17:15 19:00 15/02/2022 07:10 08:45 15:40 17:15 16/02/2022 05:00 06:00 17:30 19:00 17/02/2022 07:30 09:15 17:00 17:40 18/02/2022 06:30 08:00 16:00 17:00 TOTAL HOURS 0 0 0 0