Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Oct 2002
    Location
    Houston, Texas, USA
    Posts
    303
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Multi items and time (Excel 2K)

    I need to figure out the following: I run 7 jobs a day and I need to add 5 min. to each job. what formula would I use?
    btw, it takes 5 min to run each job.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Multi items and time (Excel 2K)

    I don't understand your question.

    If you want to add 5 minutes to an amount of time in, say A1, you can enter 0:05 in a cell, say B1 and put the formula =A1+B1 in a third cell. Alternatively, you can use =A1+5/1440 or =A1+TIMEVALUE("0:05") or =A1+TIME(0,5,0)

    If that is not what you want, please try to explain what you want to do in more detail.

Posting Permissions

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