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 |
|
rohit.manj
Starting Member
11 Posts |
 Posted - 2010-07-16 : 01:50:24
|
| hi..I am doing an exe to calculate Avg IN time And OUT time for Employee.I have my database in ms access that is from EMPLOYEE PUNCH CARD MACHINE . So I am having the data like this D1 as day1 IN 9:23 and OUT 19:34 as IN time and OUT time of employee.So i wanted to calculate the avg IN time of a employee for a month.I am able to add those values but the output is not in proper time format,suppose i want to add In time of two days like 9:53 and 9:38 it shows 18:91 instead of 19:31i want it in this format....So i Want help from you......thanx in advance.......CRhudmude |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2010-07-16 : 04:58:20
|
| convert the source numbers into minutes, do the maths on the minutes and then convert the result back into hours |
 |
|
|
rohit.manj
Starting Member
11 Posts |
Posted - 2010-07-16 : 05:36:57
|
| thanx a lot ....CRhudmude |
|
|
|
|
|
|
Wants Help