Hi. I'm trying to have Excel enter the time from column D into columns E through AB without having to do it by hand. Is there a formula to do this? Thank you so much.
Hi. I'm trying to have Excel enter the time from column D into columns E through AB without having to do it by hand. Is there a formula to do this? Thank you so much.
What should the values be if a stay lasted several days?
Entia non sunt multiplicanda sine necessitate
The values should be in minutes if it's in between the column E and AB hours. Column D should be in hours and minutes. I hope that's what you mean.
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.
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.
A UDF is a user-defined function. This UDF is one I wrote and put in the workbook I posted.
Why don't you just add your data to that workbook?
Then copy the formulas down, one whole row at a time. The formula in each row is a single array formula; see http://office.microsoft.com/en-us/ex...001087290.aspx
Last edited by shg; 05-16-2011 at 09:21 PM.
Oh ok. Sorry, I was doing it comletely wrong. Thank you again.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks