Trying to caculate hours but messes up when I go past midnight for 3rd shift. I added text box for dates begin and end but I have messed it up. Please help get userform working...
thanks
Trying to caculate hours but messes up when I go past midnight for 3rd shift. I added text box for dates begin and end but I have messed it up. Please help get userform working...
thanks
sorry, mis-read prob.
Last edited by protonLeah; 06-12-2014 at 10:11 PM.
Ben Van Johnson
Hello janusik4341,
The attached workbook has been modified and appears to work correctly. Take a look and let me know if anything needs changed.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks for all your work. Its awesome.
The total hours is coming out negative? When going past midnight not sure where to look in program?
Hello janusik4341,
Here is the updated workbook to handle the shift change across midnight.
The formula change is this this: FX(0) = "=IF(INT(RC[-2])=INT(RC[-5]),(RC[-2]-INT(RC[-2])-(RC[-5]-INT(RC[-5])))*24,((RC[-2]-INT(RC[-2])-(RC[-5]-INT(RC[-5])))*24)+24)"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks