Sorry, Forgot to say that I am using PHP 4.0.5 and MySQL 3.23.48
>Date: Sat, 02 Mar 2002 15:11:10 +0800 >To: [EMAIL PROTECTED] >From: Hoo Kok Mun <[EMAIL PROTECTED]> >Subject: Number of working hours in a month. > >Hi, > >I have look thru the website on date and time functions but nothing that I >can use. >http://www.mysql.com/doc/D/a/Date_and_time_functions.html > >How do I dynamically calculate how many working hours in a particular month? >Has anyone do it before? > >Here is the simple formula. >Add - Number of days in a month >Deduct - Sundays >Number of Mon-Fri * 8 hours >Number of Sat * 4 hours >My Figure = total working hours of a month. >I do not need to include any holidays. > >This data is for my monthly timesheets. >Currently I am hard coding it while I find a solution... --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
