Forum Discussion

joep78's avatar
joep78
Helper III
5 years ago
Solved

calculate working hours based on multiple text fields

hi all,   I want to calculate the working hours per employee but the calculation should be based on text fields:    Here an example how the data look like in the DB (with exeption of the last col...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    joep78 , You can create a new column like

    if([TypeOfDayMonday]="WD",8,0) + if([TypeOfDayTuesday]="WD",8,0) + if( [TypeOfDayWednesday]="WD",8,0) + if( [TypeOfDayThursday]="WD",8,0) + if( [TypeOfDayFriday]="WD",8,0) + if( [TypeOfDaySaterday]="WD",8,0) + if( [TypeOfDaySunday]="WD",8,0)

amitchandak's avatar
amitchandak
Super User
5 years ago

joep78 , You can create a new column like

if([TypeOfDayMonday]="WD",8,0) + if([TypeOfDayTuesday]="WD",8,0) + if( [TypeOfDayWednesday]="WD",8,0) + if( [TypeOfDayThursday]="WD",8,0) + if( [TypeOfDayFriday]="WD",8,0) + if( [TypeOfDaySaterday]="WD",8,0) + if( [TypeOfDaySunday]="WD",8,0)