how i calculated the exact over time . [message #84593] |
Thu, 01 April 2004 15:34 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
shahzad-ul-hasan
Messages: 625 Registered: August 2002
|
Senior Member |
|
|
dear all.
i have a query. i have a table like that...
field datatype
empcode number(6)
itime varchar2(20)
otime varchar2(20)
inputs are as:
100000 (his employee code)
12-mon-2003 9:20:30 a.m (his time in)
12-mon-2003 8:23:22 p.m (his time out)
( the out time of that employee is 5:30:59)
i want to calculate the exact(100% accurate)over time of that employee after his time out...if he out at the exact time of 5:30..then there is no over time...if he out at the 8:30 then the exact over time for the 1 hour is 40...
pls calculate the overtime of that employee for 40/hrs.
|
|
|
|