Start / end date and flags

[#1]

Hello,

I have a dataset containing dates and flags.

For each date, the flag tells if a device was on (flag = true) or if the device was off (flag = false)

14-10-16 01:06	TRUE
14-10-16 01:21	FALSE
14-10-16 02:51	TRUE
14-10-16 03:06	FALSE
14-10-16 04:36	TRUE
14-10-16 04:51	FALSE
14-10-16 06:21	TRUE
14-10-16 06:36	FALSE
14-10-16 08:06	TRUE
14-10-16 08:21	FALSE
14-10-16 09:51	TRUE
14-10-16 10:06	FALSE
14-10-16 11:36	TRUE
14-10-16 11:51	FALSE
14-10-16 13:21	TRUE
14-10-16 13:36	FALSE
14-10-16 15:06	TRUE
14-10-16 15:21	FALSE

How can I exploit these data to create a chart showing the device usage ?

E.g : time spent with device in status"on", per hour / day / month.

Is it possible to work with these raw data "as is" ? Or do you think I d' need to transform them ?

Regards,

Jean-Yves

[#2]

Thank you very much, John.

Regards,

Jean-Yves