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)