Formula: =IF((((E15-D15)+(G15-F15))*24)>8,8,((E15-D15)+(G15-F15))*24)
Day IN OUT subtotal non-exempt hrs REG
Friday3/7/2013 12:30 PM 4:00 PM 4 3.50
Total hours 3.50 3.50
Attempting to calculate hours of time worked, yet subtotal column seems to have a round function on the cell. The REG column is simply an =to subtotal column and it calculates correctly. How do I remove?
PS OF ISSUE.docx
Hi and welcome to the forum
Please dont copy/paste a workbook into word and then upload the word doc...upload the sample workbook...no-one wants to retype your data for you
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
To changing the format of H15 to be the same as I15.
Select I15, click on "format painter" (above column B) then select H15
Audere est facere
Hill Street,
Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
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]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks