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?
Calculation for Timestamp
Moderators: chulett, rschirm, roy