time calculations
Posted: Tue Jan 11, 2005 2:37 am
Hello
What is the best way to do this?
I have an employee database, which stores working hours of each employee. I insert the time when employee comes to work and when he/she leaves. Values in MySQL are for example in monday: field 'monday_1'= 08:14 and 'monday_2'= 16:44.
I want to get daily working hours of an employee, like "7.6" hrs etc... as a decimal number. I need this to build weekly and monthly working hour reports.
Thanks for any help.
What is the best way to do this?
I have an employee database, which stores working hours of each employee. I insert the time when employee comes to work and when he/she leaves. Values in MySQL are for example in monday: field 'monday_1'= 08:14 and 'monday_2'= 16:44.
I want to get daily working hours of an employee, like "7.6" hrs etc... as a decimal number. I need this to build weekly and monthly working hour reports.
Thanks for any help.