NeoGen   10 #1 Posted March 6, 2018 (edited) Hi all,  I'm looking for a way to make a basic project management tool in Excel, basically all I want it to do is tell me a completion time and date from the initial date/time entered.  e.g. I have something that will take 1 day 12 hours to complete, I start it on the 6th March at 9:30am (06/03/2018 09:30:00), so the completion date would be as follows: 07/03/2018 21:30:00  But it would need to deal with if it were just 4hrs for example too.  Does anyone have any suggestions?  Many thanks in advance  N Edited March 6, 2018 by NeoGen Correct Typos Share this post Link to post Share on other sites Share this content via...
swarfendor437 Â Â 14 #2 Posted March 6, 2018 Would any of the free templates offered here assist?: Â https://www.projectmanager.com/excel-project-management Share this post Link to post Share on other sites Share this content via...
NeoGen   10 #3 Posted March 9, 2018 Hi Swarfendor43,  Many thanks for your reply, I had a look at these and to be honest I'm after something a lot more basic.  Something like:  1). Start date and time Enter the day and time the project was started; 2). Days to completion (enter the number of days and hours it will take to finish, this is known beforehand) 3P. Estimated time of completion (Calculated from above fields)  Regards  N Share this post Link to post Share on other sites Share this content via...
Guest   #4 Posted March 9, 2018 (edited) Hi all, I'm looking for a way to make a basic project management tool in Excel, basically all I want it to do is tell me a completion time and date from the initial date/time entered.  e.g. I have something that will take 1 day 12 hours to complete, I start it on the 6th March at 9:30am (06/03/2018 09:30:00), so the completion date would be as follows: 07/03/2018 21:30:00  But it would need to deal with if it were just 4hrs for example too.  Does anyone have any suggestions?  Many thanks in advance  N  Should be quite easy to achieve.  Column A - start date and time Column B - duration in days / hours / mins Column C - end date and time: Column A plus Column B  You need to ensure that columns A, B and C are all correctly formatted for dates and times by using the custom format dd/mm/yyyy hh:mm.  Hope this helps. Edited March 9, 2018 by Guest Share this post Link to post Share on other sites Share this content via...
cgksheff   44 #5 Posted March 10, 2018 Are you dealing with work going on 24hours per day or just having working days of, say, 8hours? Share this post Link to post Share on other sites Share this content via...
NeoGen   10 #6 Posted March 12, 2018 Should be quite easy to achieve. Column A - start date and time Column B - duration in days / hours / mins Column C - end date and time: Column A plus Column B  You need to ensure that columns A, B and C are all correctly formatted for dates and times by using the custom format dd/mm/yyyy hh:mm.  Hope this helps.  Hi SgtDave,  Many thanks for your reply, it is column B I'm not sure about, how would I enter 12d 6hrs in to column B, how would it be formatted? If I format it as dd/mm/yyyy hh:mm I wouldn't be able to just put in 12d 6hrs. This is where I am falling down.  Many thanks  N  ---------- Post added 12-03-2018 at 08:18 ----------  Are you dealing with work going on 24hours per day or just having working days of, say, 8hours?  Hi cgksheff,  Many thanks for your reply, I am using a full calendar, 24/7/365,  Regards   N Share this post Link to post Share on other sites Share this content via...
andysm   17 #7 Posted March 12, 2018 Either have 2 separate columns for days and hours, or enter in hours only (so 12d 6h would be 294 h) Share this post Link to post Share on other sites Share this content via...
Guest   #8 Posted March 12, 2018 (edited) Hi SgtDave, Many thanks for your reply, it is column B I'm not sure about, how would I enter 12d 6hrs in to column B, how would it be formatted? If I format it as dd/mm/yyyy hh:mm I wouldn't be able to just put in 12d 6hrs. This is where I am falling down.  Many thanks  N  ---------- Post added 12-03-2018 at 08:18 ----------   Hi cgksheff,  Many thanks for your reply, I am using a full calendar, 24/7/365,  Regards   N  Hi,  You could format Column B as time only (hh:mm) and then enter 294:00:00 (ie 12 days 6 hrs 00 mins 00 secs in hours). I appreciate that having to include a value for seconds seems strange given the format is hh:mm, but Excel has its quirks. That solution works for me. Andysm's version is also feasible but the format for days would need to be number with 0 decimal places. Edited March 12, 2018 by Guest Share this post Link to post Share on other sites Share this content via...