var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Please I want to know how can I Calculate the duration between tow times for Example I've employee Start work 08:30: and end work 05:50
how can i get difference between two hours for this employee?
When you say '05:50', I guess you mean PM. Your value either needs to say so ('05:50PM') or you need to use 24 hour form ('17:50'). Assuming the latter, you could do:
to get a value in hours.
(to_date('17:50','HH24:MI') - to_date('08:30','HH24:MI'))*24
I'm curious how you have your start and end times stored.