Hello,
I'm trying to create a spreadsheet for a workweek. The program will need to calculate the total number of hours worked in a given day, determine if it is greater or less than 6 hours, if greater subtract 30 minutes for a break, if less do nothing, and return a total number of hours worked in number format.
For example, a user will input an employee as working 8am - 5pm. The program then should output 8.5. Then, add all hours together for a week and output total hours working in number format. Example, 20.5.
I'm using excel 2007, but i also need it to work in earlier versions such as excel 2001.
Thanks
Bookmarks