| time calculation [message #86948] |
Mon, 22 November 2004 19:46 |
annu
Messages: 34
Registered: February 2002
|
Member |
|
|
i m developing a time managment system .. for that i need some assistance .. in my physical system all the employies are punch there time cards for in and out. i want to record there timings .. i have three shifts in a day, total 8 hours in one shift.. 9:00 am to 17:00 pm , 17:00pm to 1:00am and 1:00am to 9:00am .. in this sitation some employes do overtime also. and u can easily see that there is a change of date also in one day . now i have to ask some questions.
let suppose i have a data like this
master
trans_date
01-jun-2004
detail
empno time_in time_out tot_hours ot_hours
101 09:00am 17:00pm 8.00 0.00
102 09:00am 18:30pm 8.00 1.50
103 17:00pm 13:00pm 12.00 4.00
1. what kind of a data type i store in forms 6i char or time ?.
2. what kind of a data type i store in table field data type varchar2 or date?
3. should i must record date also with time recording in detail table . or just time is enough.
4. how can i obtain total hours ? confusion in calculating time differnece in forms.
5. what do u suggust that i use formula calculation or triggure base calculation technique to calculate tot_hours and ot_hours.(is there any way to use item formula calculation mode to calculate time difference in forms)
6. what is the best triggure for this condition while user enter in and out timing and automatically ot_hours and tot_hours calculation display in forms.
hope so that everyone can easily understand what is my problem is .. kindy suggest me with your great ideas.. it is also appricaiable that anyone who give me reference link about time management system to understand it in better way ..
best regard
Annu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
