Forum Discussion

sherryn's avatar
sherryn
Copper Contributor
Oct 21, 2021
Solved

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.

 

excel
Formulas and Functions

4 Replies

    • Victor2022's avatar
      Victor2022
      Copper Contributor
      Feb 27, 2022

      SergeiBaklan 

      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
               

Resources