MySQL Forums
Forum List  »  PHP

Working Time Calculation in Minutes with in Business Hours between two dates
Posted by: Venkata Phani Krishna
Date: November 06, 2012 10:49AM

Hi ,

How can we claculate the Working Time Calculation in Minutes with in Business Hours between two dates

ex :
Business Hours : 08:30 AM to 05:30 PM

From DateTime : 2012-11-02 09:30 AM

To DateTime : 2012-11-05 11:30 AM

Output should be : 660 Minutes
(
2012-11-02 09:30 AM to 2012-11-02 05:30 PM : 480 Minutes
+
2012-11-05 08:30 AM to 2012-11-05 11:30 AM : 180 Minutes

* 2012-11-03 , 2012-11-04 are Saturday and Sunday
)

Thank You

Options: ReplyQuote


Subject
Written By
Posted
Working Time Calculation in Minutes with in Business Hours between two dates
November 06, 2012 10:49AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.