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

Report •

#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 am
NOT 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

MIKE

http://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. ;-)

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


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.... :-)

MIKE

http://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...

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

Ask Question