Dear All

I'm trying to add how much an employee worked during a week; however my sum formula is not acting as it should.

Example

Date Time In Time Out Total

05-May-14 09:31:00 19:38:00 10:07:00
06-May-14 09:31:00 20:11:00 10:40:00
07-May-14 08:36:00 12:45:00 04:09:00
08-May-14 08:45:00 19:54:00 11:09:00
09-May-14 10:52:00 19:09:00 08:17:00

If you drag cursor on the total column: total is 44:22:00 - which is correct
When I sum(D1:D5): total is 20:22:00 - which is wrong

I also tried sum(D1:D5)*24 but wrong sum is also given.

Any help?

Thanks