mySQL driven timesheet

[kazer]

Looking for some pointers and or examples on how to calculate time passed from two entries. Basically I want someone to click a button for login and have php send a timestamp to the database. when they log out, I want php to send another time stamp to the database and also calculate the time passed by querying the login time and current logout time to be placed into the final field total (in hourly notation).

Example:
+------+------------------+
| id   | name             |
+------+------------------+
| 01   | Employee #1      |
| 02   | Employee #2      |
| 03   | Employee #3      |
+------+------------------+

+------+----------+-------+-------+-------+
| id   | date     |  in   | out   | tot   |
+------+----------+-------+-------+-------+
| 01   | 20021022 | 1:00  | 5:15  | 4.25  |
+------+----------+-------+-------+-------+

I don't need help so much with the database aspect of it, but moreso I am confused with the calculation of time passed. Any help would be greatly appreciated!

-K

[Elena_Mitovska]

When user logs in, the timestamp get sent to database and stored in column "in" with datatype TIME, when user logs out, execute query :

Update TABLE Set out=current_time, tot=(current_time-in) WHERE id=01

where "in","out" and "tot" are columns of your table

column "tot" will store data in format " 00:48:02 ".
NOTE all coulmns "in", "out", "tot" has datatype TIME