add 48 working hours

[sandysharma]

Hi,

I need a formula that adds 48 working hours in some time. So if I am on friday then 48 working hours should give me some time of tuesday skipping saturday and sunday.

Thanks and Regards,
Sandy

 

[SirJB7]

Hi, sandysharma!
Try with function WORKDAY.
Regards!

 

[NARAYANK991]

Hi ,

Will this work ?

=WORKDAY(A1,2) + MOD(A1,1)

where A1 has a date + time value.

Narayan

 

[sandysharma]

Thanks friends for your inputs however this is what I need:
let us say I get some work on 21st July at 5 PM....I need to complete the work in
48 hours of working days. Now since 21st July is Friday my timeline ends at tuesday 5 PM...so thru formula I need 25th July as a result....by applying workday formula it just adds 2 days.....it does not skip the weekends/holidays...
I hope I am able to clear my problem...

 

[NARAYANK991]

Hi ,

You are now mentioning that your working day ends at 5 PM.

Mention also when your working day starts.

Narayan

 

[sandysharma]

21st July at 5 PM

 

[NARAYANK991]

Hi ,

Upload a workbook with enough data in it ; work out a few examples of what the output should be for a variety of input data e.g.

What should be the output for the following input dates and times ?

Monday 7 PM

Tuesday 3 AM

Friday 7 AM

Friday 11 PM

Saturday 3 PM

Sunday 7 PM

Narayan

 

[sandysharma]

For Monday 7 PM output should be Wednesday 7 PM...
For Tuesday 3 AM output should be Thursday 3 AM..
For Friday 7 AM output should be Tuesday 7 AM..
For Friday 11 PM output should be Tuesday 11 PM..
On Saturday and Sunday I dont receive the data hence no timelines..

 

[NARAYANK991]

Hi ,

That is exactly what this formula outputs.

=WORKDAY(A1,2) + MOD(A1,1)

Narayan

 

[sandysharma]

Oh Yes!!
Hope you forgive my foolishness...!! I really missed that...its working!!!
Also, Can you please explain the logic....Sorry but I am just the beginner...