# Date & Time Calculation

September 26, 2013 at 17:34:50
Specs: Windows XP
 I have to track certain activity. It is time bound. I have a tracker where I put the date the input was received alon with time, say 9/26 10:30 am, I want excel to calculate the due date automatically. If the due date is 48 hours later, I want it to return 9/30 10:30am. Possible?

See More: Date & Time Calculation

#1
September 26, 2013 at 18:38:26
 Not sure you have your math correct.If you want to add 48 hours to 9/26/13 10:30 am you new value would be 9/28/13 10:30 amNOT 9/30/13 10:30 am, which would be 96 hours.Try this, with your Date / Time in cell A1:and your Hours in cell B1, in cell C1 enter the formula: =A1+(B1/24)Your data should look like this:``` A B C Date/Time Hours New Date/Time 1) 9/26/13 10:30 am 48 9/28/13 10:30 am ```MIKEhttp://www.skeptic.com/

Report •

#2
September 26, 2013 at 21:28:36
 Well, 48 "business hours" after 9/26 would be 9/30, assuming a used-to-be-standard work week of Monday - Friday. ;-)

Report •

#3
September 27, 2013 at 09:08:20
 So, does that mean we also use a regular work day of 8 hours,which would give you a date of 10/04/2013.... :-)MIKEhttp://www.skeptic.com/

Report •

Related Solutions

#4
September 27, 2013 at 09:32:35
 Perhaps we need clarification from the OP.I was half-serious about the 48 business hours only because it was the only way I could stretch 9/26 to 9/30 by adding 48 hours. Obviously that calculation only works in the years listed at this site.http://www.timeanddate.com/calendar...

Report •