Good day dear programmers, i want to compute 1 column from another, because im developing a attendance system, and what i want to make is compute the difference between Column Time in and Column Time out, i want to put the answer to another column respectively Example:
col_time_in
2013-12-16 10:41:00
2013-12-17 8:00:00
2013-12-18 7:30:00
2013-12-19 9:35:00
2013-12-20 10:16:00
col_time_out
2013-12-16 17:00:00
2013-12-17 14:20:00
2013-12-18 15:30:00
2013-12-19 17:15:00
2013-12-20 17:20:00
I would like to compute all content of col_time_in and col_time_out to get their time difference
and all the answer will be redirected to col_totaltime, how can i possibly do that, compute all the content respectively at the same time anyone knows?
thanks :)