Adding 24 working hours

[Flydd]

Hi Guys!

I need assistance in adding 24 working hours.


Example:

A1:
Start date: 16/07/2012 12:12


I need to add 24 working hours, working hours = 08:00 - 18:00. I dont want to include weekends.

Can you help?

I have this, which i've tried playing around with, to calculate the working hours when i know the resolution date, however i cant get it to do what i want.

=(NETWORKDAYS(A2,B2)-1)*("18:00"-"08:00")-MOD(A2,1)+MOD(B2,1)

[Kevin UK]

Hi

So what is in the other cells! I see you have 16/07/2012 12:12 in A1.

[Flydd]

Well, i want a forumla to add 24 working hours to that date.

Working hours being between 8:00 & 18:00.

Cell B2 would contain the result.

Simply =A1+1 would add 24 hours or one day to it, but I want to add a 'working day'

[daddylonglegs]

Do you mean add 24 working hours, or 1 working day? (those aren't the same as 1 working day is 10 working hours in your case). If it's 24 working hours, then assuming start time/date is always within your work hours try

=WORKDAY(A2,2+(MOD(A2,1)>"14:00"+0))+MOD(MOD(A2,1)-"4:00","10:00")+"8:00"

If you only want to add 1 working day then that's simply

=WORKDAY(A2,1)+MOD(A2,1)

......or for a more generic approach, this will add the working hours shown in B2 (in time format like 20:00 or 36:00) to the date/time in A2

=WORKDAY(A2,CEILING((B2+MOD(A2,1)-"8:00")/("18:00"-"8:00"),1)-1)+MOD(A2,1)+B2-CEILING(MOD(A2,1)+B2-"8:00","18:00"-"8:00")+"18:00"-"8:00"