For some companies you need to round the input values first. For example my company would take the in/out times of 8:08a and 3:06p and round them to 8:15 and 3:00 first and credit you 6:45 hours. Whereas the formulas above would calculate (6:58) a rounded value of 7:00 hours.
Thanks for the tips! I learned new functions to work with time.
Keep Up with TechRepublic