The below code processes times entered into a TimeSheet.
andPlease Login or Register to view this content.
Please Login or Register to view this content.
It does the job, except if the END TIME is Less than(next day: After 12:00AM), in which case i get a Negative hours number in thePlease Login or Register to view this content.
I previously tried creating this TimeSheet with Formula's but it got too messy.Please Login or Register to view this content.
I then used something like:
=IF(A9<A8,(A9-A8)+(A8>A9)*24
And got the correct result when the end time was in the next day.
So i used the same theory for VBA, but it does not work when i tried:
Please Login or Register to view this content.
How can i solve this?Please Login or Register to view this content.
Bookmarks