Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: easy problem for you to solve. time problems

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I am very new to Excel and I use it not much. But my problem is: I have to add different times to a total time.

    person A worked 2:30(hh:mm) hours, person B worked 1:35 hours, person C worked 4:54 etc. Now I want to have a cell with the totall time (in this case it should be: 8:59).

    Can anybody help me please.

    Edwin


    BTW English is not my native language so sorry if I have writen something wrong.

  2. #2
    New Member
    Join Date
    Mar 2002
    Location
    Glasgow, Scotland
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Edwin, simplest way is to format the cells using custom formats as hh:mm then as long as you input the hours worked as eg 02:30 or 12:20 when you sum the cells in the normal way you should get the answer 14:50.

    Regards

  3. #3
    New Member
    Join Date
    Mar 2002
    Location
    Glasgow, Scotland
    Posts
    8
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Edwin, simplest way is to format the cells using custom formats as hh:mm then as long as you input the hours worked as eg 02:30 or 12:20 when you sum the cells in the normal way you should get the answer 14:50.

    Regards

  4. #4
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-28 02:37, almar_dc wrote:
    Hi Edwin, simplest way is to format the cells using custom formats as hh:mm then as long as you input the hours worked as eg 02:30 or 12:20 when you sum the cells in the normal way you should get the answer 14:50.

    Regards
    Thanks. That worked but if the total time is more than 24 hours he will start to count from zero again and I am missing 24 hours. What to do with that?

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Newcastle, UK
    Posts
    1,174
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Change the Format of the cell to Custom Format, and use [h]:mm or [h]:mm:ss as required
    "Have a good time......all the time"
    Ian Mac

  6. #6
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanx very much. It works just fine now.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •