+ Reply to Thread
Results 1 to 13 of 13

Time Calculations with tagged wording

  1. #1
    Registered User
    Join Date
    05-05-2012
    Location
    Dublin
    MS-Off Ver
    Excel 2003
    Posts
    8

    Time Calculations with tagged wording

    Ok so I am trying to input a list of times with names attached under 4 headings then depending on where they are input either 0,5,10,or 15 seconds is added and a list of the new times under each heading is made. The idea is the then take all those times listed and order them from largest to smallest according to the time but include the original name.

    The problem is I cant figure out how to stick the names in b5,b6,b7 etc to the formula adding the time =SUM(C5,E5) , =SUM(C6,E5), =SUM(C7,E5) etc etc =SUM(C23,F5)....so that is reads something like 08:43:26 "Name"...since I havn't gotten through that step I havn't even started on how I take those values in 4 colums and mix them into one list in order of highest number to lowest with the names included beside them.

    Ive looked for the way of doing it but can't seem to find it and when I thought I got it I just get a long decimal number instead of the time and name....

    Any help would be great!

    Thx for your time.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Time Calculations with tagged wording

    Do you mean something like
    Please Login or Register  to view this content.
    ?

  3. #3
    Registered User
    Join Date
    05-05-2012
    Location
    Dublin
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Time Calculations with tagged wording

    Thx for responding :D

    I have tried that before and I come up with something like "0.3652..... Name" I need it to be displaying a time in the format 00:00:00 <hours min sec then have the name from the previous cell tagged with it so I can then sort the times in order without losing which name goes with which time...

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Time Calculations with tagged wording

    will something like this work for you?.....

    =HOUR(C5)&":"&MINUTE(C5)&":"&SECOND(C5)&E5
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    05-05-2012
    Location
    Dublin
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Time Calculations with tagged wording

    While it does give me the correct time, I want that result to be entered into a cell with the name of the from cells in the B colum that match. So that I can then sort those highest to lowest in a further table and the time will all have the right names.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Time Calculations with tagged wording

    perhaps you should upload a sample for us to look at?

  7. #7
    Registered User
    Join Date
    05-05-2012
    Location
    Dublin
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Time Calculations with tagged wording

    This is the rough draft
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    05-05-2012
    Location
    Dublin
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Time Calculations with tagged wording

    Just gonna bump the thread.

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Time Calculations with tagged wording

    ok, i have your file. I cant see any examples of what you want your answer to look like, and where you want it to be. could you talk me through it please?

  10. #10
    Registered User
    Join Date
    05-05-2012
    Location
    Dublin
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Time Calculations with tagged wording

    Ok so the names of times are recorded in the B colum. The C colum has the times entered in 4 different places, each different input area connects to a cell ( E, F, G and H5) adding 0, 5, 10 or 15 seconds to the time. In the J, K, l and M I want the result of the adding in seconds to display with the name that comes with that time so C5 + added time with text from B5 beside it. Then I want to take all the data in those last four colums and put it in order in another colum with the longest time first going in decending order to the lowest. Do you understand what I am trying to say?

  11. #11
    Registered User
    Join Date
    05-05-2012
    Location
    Dublin
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Time Calculations with tagged wording

    Ok so the names of times are recorded in the B colum. The C colum has the times entered in 4 different places, each different input area connects to a cell ( E, F, G and H5) adding 0, 5, 10 or 15 seconds to the time. In the J, K, l and M I want the result of the adding in seconds to display with the name that comes with that time so C5 + added time with text from B5 beside it. Then I want to take all the data in those last four colums and put it in order in another colum with the longest time first going in decending order to the lowest. Do you understand what I am trying to say?

  12. #12
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Time Calculations with tagged wording

    sounds like all you need to do is, from my suggested formula, move the last part to the front. i ghave adjusted it to match your references, try it and let me know if that is what you want?

    =J$5&" "& HOUR($C5+E$5)&":"&MINUTE($C5+E$5)&":"&SECOND($C5+E$5)

  13. #13
    Registered User
    Join Date
    05-05-2012
    Location
    Dublin
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Time Calculations with tagged wording

    yea when I alter the J$5 to be B$5 that works but can I put word after the number so I can sort by the time value?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1