Sharepoint Online - Calculated date time column to subtract integer under hour value


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'?




0 Replies