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
Bookmarks