Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
.
is this the data in the column ?
.
what is your expected output?
Here is the way you can approach.
convert all values to hours
----------------------------------
create a MAPPING load like
working days, 7.5
office, 1
from SLA fields take out the Number Part and String part by using String functions
Use ApplyMap() and pass String Part to fetch related numbers
Multiply that with Number part i.e. 2*7.5 , 4*1 etc
Now you have total hours with decimal values
Use maketime() function to get desired output of HH:MM:SS
--------------------------------------------------