mithun kumar

mithun kumar

  • NA
  • 20
  • 17.7k

Add Date time as per woking Hours

May 28 2012 3:31 AM

Hello Friends,

Assume now the current Date Time is 27-05-12 15:00

I want to add:-1 days 5 hours 00 min

Or

Suppose your working Hour is 9:00 to 17:00(5'o clock)

1-You got one task at 27-05-12 15:00 (Date time)
2-And you said I will take 13 hours to complete this task.
3-That's mean today you have 2 Hours(15:00 to 17:00) work and tomorrow 8(9:00 to 17:00) Hours works and day after tomorrow 3(9:00 to 12:00) hours works to finish 13 hours. So the Output date time to finish this task will be will be as follows

Output should be:
29-05-12 12:00

Note: conclusion is that when you will say I will take 780 min or 13 Hours system automatically calculate the finish Date time

Thanks & Regards,

Mithun.


Answers (8)