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 |
|
nuruddean
Starting Member
11 Posts |
 Posted - 2011-05-11 : 04:54:39
|
i have 1 table
table = attendance
actual_time_in = 04/02/2008 8:04:29
actual_time_out = 04/02/2008 17:14:24
so how i want to get the total hours fot that day?
My Name is Nuruddin |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2011-05-11 : 05:02:36
|
[code]datediff(minute, actual_time_in, actual_time_out) / 60.0[/code]
KH
[spoiler]Time is always against us[/spoiler]
|
 |
|
|
|
|
|
calculate total working hours