A lot more info is needed...
There are so many date / time functions available. Also are you taking inputs directly or selecting from tables?
Here are a few to get you started:
SELECT TO_DATE('01/01/1900 00:59:59','mm/dd/yy hh24:mi:ss')
, to_char(sysdate, 'HH:MM:SS')
, TO_CHAR(SYSDATE + 1/(24*60*60),'HH24:MI:SS')
day_elapsed := 24*EXTRACT(DAY from (time_out - time_in));
hr_elapsed := EXTRACT(HOUR from (time_out - time_in));
min_elapsed := ROUND(1.6667*EXTRACT(MINUTE from (time_out - time_in)),0);
time_elapsed := TO_NUMBER((day_elapsed + hr_elapsed) || '.' || min_elapsed);
SELECT (time_out - time_in) Time_performed
Add details to the discussion and maybe we can be more specific
Last Wiki Answer Submitted: October 27, 2009 2:29 pm by Dmcdconsult40 pts.