Excel problem with adding up Hours Worked

  wee eddie 17:19 08 Aug 2008

This is my Set-up

Start Time - Finish Time = Hours Worked

08:40:00 - 17:50:00 = 09:10:00,

in other words, 9 hours and 10 minutes.

This happens for each of the 4 subsequent days but on each day the Start and Finish Times vary.

The Question: How do I add up the 'Hours Worked' for the week.

The Formula =Sum(C1:C5) does not work, it produces a figure 08:40:00 rather than a figure of, say 43:10:00, which is what I would have expected.

  lotvic 20:03 08 Aug 2008

I'm not an expert on Excel but click here shows how to format the cell to add them up properly

hope it helps

  wee eddie 21:40 08 Aug 2008

It took me a while to get my head around it but I got it in the end.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Huawei MateBook X Pro review

8 digital brands that designed custom typefaces to save millions

How to speed up a slow Mac

Comment résoudre des problèmes d’impressions ?