Total hour calculation

Here with I have attached excel worksheet. I need to calculate daily work hours and at the end calculate total hours.

Thank You

Status Date/Time

START JOB 28/08/2014 / 15:53
END JOB 28/08/2014 / 16:53

START JOB 27/08/2014 / 09:18
END JOB 27/08/2014 / 09:29
START JOB 27/08/2014 / 13:15
END JOB 27/08/2014 / 15:18

START JOB 26/08/2014 / 10:31
END JOB 26/08/2014 / 12:33
START JOB 26/08/2014 / 13:20
END JOB 26/08/2014 / 17:14

START JOB 25/08/2014 / 10:41
END JOB 25/08/2014 / 17:36

START JOB 19/08/2014 / 09:05
END JOB 19/08/2014 / 12:30
START JOB 19/08/2014 / 12:58
END JOB 19/08/2014 / 14:25

START JOB 18/08/2014 / 11:17
END JOB 18/08/2014 / 12:48
START JOB 18/08/2014 / 13:14
END JOB 18/08/2014 / 17:28

START JOB 13/08/2014 / 09:03
END JOB 13/08/2014 / 12:28
START JOB 13/08/2014 / 12:59
END JOB 13/08/2014 / 17:09

START JOB 12/08/2014 / 09:03
END JOB 12/08/2014 / 12:33
START JOB 12/08/2014 / 12:59
END JOB 12/08/2014 / 17:09

START JOB 11/08/2014 / 09:03
END JOB 11/08/2014 / 12:30
START JOB 11/08/2014 / 12:59
END JOB 11/08/2014 / 17:09

START JOB 08/08/2014 / 09:14
END JOB 08/08/2014 / 12:31
START JOB 08/08/2014 / 12:57
END JOB 08/08/2014 / 14:43

START JOB 07/08/2014 / 09:10
END JOB 07/08/2014 / 12:31
START JOB 07/08/2014 / 12:58
END JOB 07/08/2014 / 13:17

START JOB 06/08/2014 / 09:06
END JOB 06/08/2014 / 12:30
START JOB 06/08/2014 / 12:59
END JOB 06/08/2014 / 17:04

START JOB 05/08/2014 / 09:04
END JOB 05/08/2014 / 12:32
START JOB 05/08/2014 / 13:06
END JOB 05/08/2014 / 13:09

START JOB 04/08/2014 / 09:43
START JOB 04/08/2014 / 09:50
END JOB 04/08/2014 / 09:50
END JOB 04/08/2014 / 12:30
START JOB 04/08/2014 / 13:06
END JOB 04/08/2014 / 17:18

START JOB 01/08/2014 / 09:28
PAUSE JOB 01/08/2014 / 10:38

Got the solution..
Formula:-

Formula:

Please Login or Register  to view this content.

Check the attached file..'

See the attached file