Outlook Forms - Calculating Time Spent At Work?
Posted on 2008-10-31
I am working on a form to calculate time spent at work, based on when the person started (8am), when they finish (5pm), and how long they have for lunch(1hour).
I have my calculations to do work out the total time spent at work, however the difficulty comes with the time for lunch. If a person decides to take only 30mins for lunch then their total time worked should increase, however I don't know what type/property to use for this? Duration seems to just give hours, and modifying it in Date/Time means that 1:00 becomes 00:30 (half 12 at night). It is all in the 24hour clock.
Does anybody know what I can use as the most appropriate type/property in order to subtract the time taken for lunch from the total hours worked?