Microsoft Office Questions? Ask a IT Expert for Support ASAP
not sure what you are asking? Can you attach a sample file of your goal.
YOu can attach a file using the paperclip icon at the top of this chat window
you can send an email to***@******.*** and say you need to send me a file in relation to this question. However you should note, it may take some time for them to get the file to me.
However not sure how you would send me a file from a phone.
they sent your file to me, what is it you are trying to accomplish?
i don't understand what do you want your formula to do? What is your goal?
ok, tell me which formula to copy, from which cells to which cells, and where you want the result.
after reviewing my workload, I think it would be best if I opened this question to other experts.
You do not need to do anything and the next expert will be able to see everything, so you wont need to explain it again.
Sorry I did not answer this earlier, I did not get an e-mail until last night, and it should have come immediately. JustAnswer had sent me the files and I asked what was happening and what I got back was:
I'm sorry for the confusion, I forwarded the photos to you by mistake. It is intended to be forwarded to Expert The-PC-Guy.If there's anything more I can do to assist you today, please be sure to let me know.
I have the files, I will start looking at them now.
Okay, I think I fixed it. xslx file without macros is attached below. Here is the link to the xlsm file with the macros in for all six applicable columns: http://www.mediafire.com/view/kw0l4i6z7wu4z2h/Gradys_blank_road_map_rev01.xlsm
Just so you know. On JustAnswer, when it does not allow you to attach a file or the link does not work and you need to get it to someone, there are two free services you can use to upload to and then copy and paste the address to allow downloads, wikisend.com or mediafire.com. Wikisend you put it up and get the http address and it stay sup for like 7 days, no account needed. On Mediafire you can upload and share and use passwords, but it requires an account. Customers typically use wikisend because it's free and simple, I use mediafire because I do this a lot (and I can upload files I may want when I travel). Just FYI.
Let me know how those two files work for you and what else you need. Sorry again for not seeing this question pop earlier.
It was a formatting issue. The formatting was set to general, I shifted it to time (specifically the time that gives the 13:30 example in the additional number formats when you click format). Here is a link to the xlsm: http://www.mediafire.com/view/by8nei3ocahehv8/Gradys_blank_road_map_rev02.xlsm
Yeah, that requires a much more complicated formula. I can work on that.
It's fine, it's just going to be a massive formula.
Can I add a column, for hours, that calculates the hours of the shift. I guess you could always hide it later anyways, but it just makes it easier to see the formula.
thank you, ***** ***** a whole lot easier.
I did it for the Days, dealer without the extra column, just need to adjust the other columns, about 30 minutes to make sure I get everything.
18:00 to 01:30 would to EO 0.5hrs right?
Here is a link to download the update: http://www.mediafire.com/view/2ddw6l24sb7bo5j/Gradys_blank_road_map_rev03.xlsm
Let me know how this is working for you and what else needs to be done. When I have answered your question fully, please remember to rate my service. Thank you.