LinkBack URL
About LinkBacks
No, it's not.
It makes sense (to me) that the total of the minutes should equal the total stay. So if someone checked in at noon, and then checked out at noon two days later, all the cells should be 120.
No, it's not.
It makes sense (to me) that the total of the minutes should equal the total stay. So if someone checked in at noon, and then checked out at noon two days later, all the cells should be 120.
Entia non sunt multiplicanda sine necessitate
Yes your right. I didn't know I had any like that went that far.
See if the attached does what you want. I punted and used a UDF.
I tried the formulas and everything came up #NAME?. Do I change something in the formula?
You have to enable macros when prompted. See http://grok.lsu.edu/Article.aspx?articleId=6144
OMG!!! It worked!!! God bless you fellow Texan!!
Ok I enabled macros. Should I just be able to add to it now?
And I don't know what punt or UDT mean either. I enabled macros and tried to duplicate ur formulas but it still wouldn't work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks