LinkBack URL
About LinkBacks
as you can see on the attached form I have a start stop macro built in. my issue is when the time crossed midnight it goes to a negative number. I need this to do the correct math even crossing midnight7400.xlsm
as you can see on the attached form I have a start stop macro built in. my issue is when the time crossed midnight it goes to a negative number. I need this to do the correct math even crossing midnight7400.xlsm
Can't see anything but i suspect you're using times only when the date is also important to capture the midnight crossover.
Elegant Simplicity............. Not Always
so shoud i format the cells to reflect date as well.
I've checked your workbook and everything seems to be in order calculation wise.
What you may possibly need to guard against is writing out times which are earlier than In times but for some reason I can't get your macro to run properly so i can't check exactly what it's doing.
You can use =MOD(endTime+1-StartTime, 1) to allow for non dated entries when the difference will always be less than 24 hr.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks