Compute all column and put the answer in another column respectively

Question

0.00/5 (No votes)

See more:

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 :)

Posted 1-Feb-14 2:25am

Edwardine Ocampo

Add a Solution

Comments

H.Brydon 1-Feb-14 15:09pm

This looks a lot like homework, which is not the purpose of this forum. I am surprised that you already got a couple of responses.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Madhav Hatwalne · Answer 1 · 2014-02-01T02:46:00

It's very simple instead of asking such questions try to google out and get some answers it will help you throughout your development career

Here is 1 of many of link

http://stackoverflow.com/questions/17278791/computed-column-specification-in-sql-server-time-difference-in-hours-or-minute[^]

Karthik_Mahalingam · Answer 2 · 2014-02-01T06:51:00

Solution 2

check this similar question
http://forums.asp.net/t/1188751.aspx[^]

Posted 1-Feb-14 6:51am

Karthik_Mahalingam