Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

need help with sum and time

Latest post Sun, Jun 13 2010 4:47 PM by Bob Phillips. 1 replies.
  • Sun, Jun 13 2010 8:53 AM

    • egbert
    • Not Ranked
    • Joined on Sun, Jun 13 2010
    • Posts 1
    • Points 21

    need help with sum and time

    hi. i am setting up what time I am working in the week and want to sum it up to see how many hours that is a week, but i have never used excel before at least not like this. Any tips on how i am doing that?

    • Post Points: 21
  • Sun, Jun 13 2010 4:47 PM In reply to

    Re: need help with sum and time

    Have the days going down in A2, A3, etc, lik Mon, Tue

    In B2, enter the start time for Monday in the format 08:15 (excel will know that is time).

    In C2, enter the end time in the same format.

    In D2, enter the formula, =C2-B2 and format (Format>Cells>Custom) as hh:mm.

     

    This will give your weeks times, then in cell C7 enter the formula =SUM(C2:C6), and format that as [h]:mm his is to cater for moree than 24 hours worked.

    Regards

    Bob

    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.