Unable to do calculation on time based objects.

[former_member184624]

Dear HANA Experts,

This is a query based on the below link.

https://answers.sap.com/questions/13692974/convert-seconds-to-hour-in-calculated-column.html

Using the below statement in Calculation column, i am getting the output in hours. For example, 7200 seconds. In report it will show as 02:00:00. I have set the column type as "Attribute". As per the requirement, I want to perform some calculation.

For example 02:00:00 / 2 = 01:00:00. As the column type is Attribute, I am unable to do any calculation. Can you please help on this.

to_varchar(add_seconds (to_timestamp ('2000-01-01 00:00:00'),"WK_FDS"),'hh:mi:ss')