I have to calculate the time difference of status from 0 to 1.
for example
If status was down at 2008-04-04 00:00:00 to 2008-04-04 02:10:00 and again if the status was 0 at 2008-04-04 03:00:00 to 2008-04-04 03:10:00
I should calculate as time differnce was 2hrs 10 min and
also 10min.
I mean to calculate the time when status was 0 for a day