Can someone please help me figure out two formulas. Columns E and F would be entered manually as military time. Column G would have to add any hours between E and F where column E would have a time between 14:01 and 4:59. Column H would need to calculate hours where column E would have a time between 5:00 and 14:00. Please help as my job entails alot of the HR timekeeping along with my operational management. Column L would calculate total hours. Thanks in advance for your help.Timesheet1.xlsx
Last edited by swoznia; 05-23-2012 at 05:57 PM.
Hi, the attachment doesn't seem to open...
How about now? I tried to reload it and I can open it from thread. Thanks.
Swoznia,
Welcome to the Forum, unfortunately:
This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.
Thread Closed.
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