Skip navigation links

MySQL Forums :: PHP :: Working Time Calculation in Minutes with in Business Hours between two dates


Advanced Search

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: Reply•Quote


Subject Written By Posted
Working Time Calculation in Minutes with in Business Hours between two dates Venkata Phani Krishna 11/06/2012 10:49AM
Re: Working Time Calculation in Minutes with in Business Hours between two dates laptop alias 11/07/2012 03:59AM


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

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.