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

Visitor

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. 

Alois_Oh_0-1640763510009.png

The actual output of this 'Actual Time Taken' is shown as:

Alois_Oh_1-1640763666766.png

 

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

 

 

0 Replies