Time card formula
Posted: Mon Nov 10, 2003 4:24 pm
i am kind of new to php, and i am trying to write a timecard app. but i am having a problem trying to come up with the formula that calculates how many hours an employee has worked. the table in the db contains
timeid :: unique id
coid :: company id
employeeid :: employee id
date :: the date
time :: the time
action :: either in or out
employees can clock in or out multiple times durning the day. i just need to figure out how to calculate the total time an employee has been working.
thanks