DSXchange

duration = (end_time - start_time) in hour , decimal(10,4)
availability = % of duration in 24 hour, decimal(5,2)

e.g
duration = (2004-07-09 15:33:35 -2004-07-09 15:28:35) * 24
availability = (2004-07-09 15:33:35 -2004-07-09 15:28:35) /24 * 100

Can this calculation be done in DS?

Yes it is possible to do in DataStage. It is just a matter of passing the parameter and using the correct conv functions to do. According to your parameter the conversion will change.

Cheers
Rasi