summing up hours and minutes
oaisApr 11 2009 — edited Apr 13 2009Hi ,
In our sign in/out system at the company there is a column in a table that shows how many hours/minutes/seconds the employees are late everyday , the data stored in this column is in this format HH24:MI:SS , they want a report from me to show the total amount of late hours/minutes of each employee during a certain period, how do i sum up this column ? i don't know if the sum function can be used with this type , which i doubt it ...
Thanks in advance...