Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Script Library
 calculate total working hours

Author  Topic 

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

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]

[spoiler]Time is always against us[/spoiler]

Go to Top of Page

- Advertisement -