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...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Oct 21, 2021

sherryn 

It could be

=D3-C3 - IF( E3 = "No", 0, E3)
  • 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
             
  • sherryn's avatar
    sherryn
    Copper Contributor
    Oct 21, 2021

    Thanks SergeiBaklan that has worked.

Resources