Formula for Timesheets using IF THEN Scenario

[sherryn]

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.

[#2 · Accepted solution]

@sherryn 

It could be

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

[#3]

Thanks @Sergei Baklan that has worked.

[#4]

@sherryn , glad it helped

[#5]

@Sergei Baklan 

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