Posted by Mike Consolo on August 08, 2001 2:40 PM
To Whomever Can Help-
I am trying to calculate the sum of hours that someone might work. I have no problem calculating the hours per day. But when I try and add the total for each of those days together it does not show as 40 or 50, etc.
For example 8 hours on Monday, 8 hours on Tuesday. I would enter 8:00 through 16:00 for each of those days. It would calculate the hours for that day as 8:00(16:00 minus 8:00). However when I add the time for each of those days (8:00 plus 8:00) it does not return the correct value(16).
Can someone tell me how I can use calculations with time.