Working with time function to determine actual time
Posted on 2013-01-29
My company doesn't pay overtime, but does give comptime. when a user travels on a non-workday they are given comptime for the travel portion of their day. As an example:
User travels on Sunday 2/3/2012 leaving from Germany and going to the home office in Washington DC. The company gives 3 hours comptime before boarding the flight plus the length of the flight plus the time to get to the hotel or office. If I take the time of departure say 11:30am and time of arrival 14:30pm comptime would be approx 7 hours (3 pre-departure, 3 based on time of departure and time of arrival, and 1 for taxi to hotel). when in fact the flight is 9 hours long so actual comptime earned is 13 hours.
1) how do I do this?