Hello I would like to add up multiple time in and time out for my pay sheet.
As you can see, the total hours worked for Weed A is correct, but the Total Hours Worked for Monday is incorrect. The forumla I am currently using is:
=((B12-A12)*24)+((B13-A13)*24)+((B14-A14)*24)
But I would just like the total hours worked for each day to be the actual hours (2.5 hours)
Any help is appreciate
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Yes, I did solve it. It was a silly overlook. My total hours worked for each day was formatted as "time." When I changed it to be formatted as "number," it should the total hours for that day (ie 3.5 hours).
Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks