Excel problem with adding up Hours Worked

  wee eddie 17:19 08 Aug 08

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 08

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 08

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…