Hello!
I have this LITTLE problem. I'm making a net application/database for taking up hours, how long i have been at work.
In MySQL, I can calculate the hours that i have been working like this: i take a unix_timestamp out of 12/12/12 14:12 and then decrease it from 12/12/12 12:12, and then sec_to_time and voilá, I have the hours that i have been working. But, how can I do it with MySQL/php?
My Page would contain a simple table,
Place(where i have been working), starttime, and stoptime
and it the php script would send it to mysql database, and when i want to see when i have been working, mysql or php would calcute, how long i have been working. But how to make it?
Please Help!
T:jonni
p.s. I'm very sorry for my very bad english, but I hope that you can forgive me 🙂