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?

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 amMIKE

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.

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

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.

Ask Your Question

Weekly Poll

Have you played Jackbox during the pandemic?

Discuss in The Lounge

Poll History