Qlikview12 - Calculate downtime for server ID

[loke2014]

Hi,

I'm trying to figure out how to retrieve the downtime for each server ID below based on the following sample data.

Date/Time                              Server ID       Status

01-Dec-2015 00:00:21           XBG-01          Down

01-Dec-2015 00:00:45           XBG-04          Down

01-Dec-2015 00:05:03           XBG-01          Up

01-Dec-2015 00:08:30           XBG-03          Down

01-Dec-2015 00:12:49           XBG-04          Up

Any help would be much appreciated.

Thanks.