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
