How would this be written as an equation on excel?

Hi Damon, . I have written a .xls worksheet to do what you describe. You can download it from: . http://funadvice.com/r/bmqvs0jd8ja . the link takes you to a file called ….. Damon.xls that I have posted to Mediafire.com. You will probably find it pretty staightforward to download. . ….. If you (and your virus scanner) are satisfied that it is safe, you should be able to open it in any version of Excel released within the last eight years or so (I used the Office XP Professional version). . Alternatively, I can knock together some instructional material for you, to explain how you go about solving these sort of problems. . However, there are a number of possible pitfalls and obscure concepts that go a bit beyond simple mathematics. It is probably not as straightforward as you expect getting time and date information into Excel easily, in a manner that it can manipulate and display in the form of meaningful results, whilst keeping everything “user-friendly”. . I am happy to post any explanatory stuff, either onto the open boards here, or send via FunMail if you prefer. . N.B. Having read Colleen’s reply, I am now not sure whether you intended to include rest times within the hours you specified (as I am assuming at the moment), or exclude them so that the 50 hours is all working time - spread over rather more working days as Colleen seems to be suggesting. . Perhaps you can clarify this point for us. .

– Best wishes - Majikthise. .

basically my dad works with this trucking company and he has an excel spreadsheet with how many hours it takes to get a job done. i helped him put all of the equations together so he knows how many hours will be spent on the trip, but he is trying to come up with an equation to let him know the time (in military time) when the trucker will return from his or her assigned task.

and yes the rest times are included in the overall equation.

for example if a job is calculated from my spreadsheet to take 50 hours to complete, the driver had the appropriate 10 hour rest time which is included in the 50 hours.

This is perfect!! Thank you so much, i’m sure he will really appreciate this!

Hi Damon, . The .xls file that I posted to Mediafire.com (linked to by my other answer to your question) will do exactly what you want then.
. I have protected all the cells on the active sheet except those coloured blue that are for data entry. (In order to prevent the calculations being accidentally changed) . The protection is not password protected, . so [Tools] [Protection] [Unprotect sheet] will remove that protection and allow you to insert the work you have already done in finding “… how many hours it takes to get a job done …” . You could then make the blue cell at C12 link to your total number of hours calculation, . ….. by entering =Xnn into cell C12 (where “Xnn” is the cell location you have used for the total number of hours).
C12 will accept either whole hours or hours including fractional parts (e.g. 50.5 would be interpreted as 50 hours 30 minutes). . Alternatively, if you have calculated the total time in minutes - that can be transferred into the blue cell at E12. . If you have separated the hours and minutes, transfer your values into C12 and E12 as appropriate. . I presume that by “military time” you just mean standard 24 hour clock with format hh:mm, in which case the file I created does the trick. . Good luck with it. .

– Best wishes - Majikthise. .

Cool, glad to have been able to help a bit.