+ Reply to Thread
Results 1 to 4 of 4

Next starting time calculation

Hybrid View

  1. #1
    Registered User
    Join Date
    07-06-2016
    Location
    Manchester
    MS-Off Ver
    Office 2007
    Posts
    2

    Next starting time calculation

    Hi all,

    I believe someone already asked this question but I cannot find it or figure out how to calculate time in Excel 2007.
    Here is the example:

    column C represent start time in hh:mm format
    column D represent job hours

    all I need is a formula to calculate what time the next job starts, so C7 is 08:00, D7 is 10, Ideally I`d like to get 18:00 in the column C8 automatically after D7 is updated.

    Going forward I`d love to update the column D only with number of hours for the job required and get starting time.

    thanks

  2. #2
    Registered User
    Join Date
    06-15-2016
    Location
    here, there
    MS-Off Ver
    2010
    Posts
    59

    Re: Next starting time calculation

    Excel does hours in a decimal system. 24hours = 1
    6 hours is = 6/24 = 0.25
    I hope this helps.

    I did just do an answer that you can look at which might point you in the right direction
    http://www.excelforum.com/excel-form...atachment.html

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,077

    Re: Next starting time calculation

    in C8
    =C7+TIME(D7,0,0)
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Registered User
    Join Date
    07-06-2016
    Location
    Manchester
    MS-Off Ver
    Office 2007
    Posts
    2

    Re: Next starting time calculation

    Thanks mate, that`s the one I needed

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Monthly tax calculation starting June and ended in May
    By le0245 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-07-2017, 10:41 PM
  2. Starting a new calculation loop when a new entry in column A is reached
    By Kickk05 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-22-2016, 10:29 AM
  3. Starting Week number by specific time
    By naiconn in forum Excel General
    Replies: 5
    Last Post: 12-03-2014, 08:37 AM
  4. Replies: 5
    Last Post: 09-27-2012, 07:30 PM
  5. [SOLVED] Excel Find Starting and finishing Time
    By Iceman1988 in forum Excel General
    Replies: 8
    Last Post: 07-16-2012, 10:23 AM
  6. Help with starting a macro with a change in DDE time value?
    By oneday in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-15-2010, 09:21 AM
  7. returning macro value to starting cell (different each time)
    By sony654 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 02-11-2006, 01:10 AM

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