Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pnasz
Posting Yak Master
101 Posts |
 Posted - 2010-10-13 : 01:40:57
|
| I have a table with column TimeIN, TimeOut, HrWorkedin hrWorked column i want TimeIn-TimeOut can you help |
|
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
Posted - 2010-10-13 : 01:52:54
|
| Not clear ..Give some more examples.. |
 |
|
|
pnasz
Posting Yak Master
101 Posts |
Posted - 2010-10-13 : 02:01:57
|
| I want a calculated field which can calculate Hrworked automatically using formula as i insert timein and timeout |
|
|
|
pnasz
Posting Yak Master
101 Posts |
Posted - 2010-10-13 : 02:04:33
|
| TimeIn TimeOut HrWorked11:30:10 12:45:10 (Should be calculated automatically using formula) |
|
|
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
Posted - 2010-10-13 : 02:26:43
|
| select datediff(s,TimeIn , TimeOut )Try this.. |
|
|
|
|
|
|
adding formula to column in table