Hi All,
As the title suggest, I have a calculated date time column named 'Actual Time Taken' that uses Actual End - Actual Start (both are date time fields). I then presented the results in a readable and neater way using the formula below.
The actual output of this 'Actual Time Taken' is shown as:
The challenge now is I have another column named 'Break Time' that is a number type. This field is input by users and has only dropdown hourly options such as 1,1.5,2,2.5, etc.
I have another calculated column named 'Actual Time Taken with Break'. How can I achieve the deduction of hourly value using 'Actual Time Taken' - 'Break Time'?
Regards,
Alois