SOLVED

Formula for Timesheets using IF THEN Scenario

New Contributor

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.

sherryn_0-1634855065259.png

 

4 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@sherryn 

It could be

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

Thanks @Sergei Baklan that has worked.

@sherryn , glad it helped

@Sergei Baklan 

Any help for this?

DATEWORKING HOURSHOURS
START TIMEON SITEOFF SITEFINISH TIMESTD HOURSx1.5x2TOTAL
14/02/202207:4009:0017:1519:00    
15/02/202207:1008:4515:4017:15    
16/02/202205:0006:0017:3019:00    
17/02/202207:3009:1517:0017:40    
18/02/202206:3008:0016:0017:00    
         
    TOTAL HOURS 0000