I'm building a database to track employee time data (time in and out, lunch times, etc.). I need a column to calculate the Total Hours worked by an employee. I'm having trouble with structuring the query to calculate the total time in hours if, say the employee comes in at 9AM and leaves at 5PM; I need it to say the employee worked 9 hours, not -4.
Any ideas on how to word the query? Any help is greatly appreciated! You can respond to my email address directly. Thank you!
Any ideas on how to word the query? Any help is greatly appreciated! You can respond to my email address directly. Thank you!
