To get the number of hours worked you would use =F25-D25 for the AM and so on for each of the other 3 periods. Then you can use the =SUM formula to add up the total number of hours worked. Just make sure all of the cells are formatted to display time.
No comments:
Post a Comment