LinkBack URL
About LinkBacks
Hello again,, sorry if I'm always troubling the people in this forum, see the attachment for more.
truble3.xlsx
i'm sorry i forgot the file to upload.
correct function to find a correct time value
Hello again,, sorry if I'm always troubling the people in this forum, see the attachment for more.
truble3.xlsx
i'm sorry i forgot the file to upload.
Last edited by jekidi; 07-06-2013 at 12:45 AM. Reason: forgot attachmet
- jekidi
can you please explain exactly what you are trying to do?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
FDibbin please see the attachment the problem is in the attach
I did, thats why I asked my question
Something is wrong with your data. If you double click into each cell (relevant for your SUMIFS function) your data type corrects itself and then you will get your answer. This has happened to me before, and I'm not sure what causes it. You will also need to change the format for time entries. I used the "37:50:05" time format. I also made changes to your other two formulas. I've attached my changes to this email.
Your INDEX MATCH formula is an array formula so make sure you do the "ctrl + shift + enter" to get the correct answer.
truble3.xlsx
okay thanks for the answer Brown Boy.
i understand now.
When a date is in fact text looking like a date an easy way to convert to correct time is to select the column - Data - Text to Columns - Finish
Same with time
Thanks Pepe Le Mokko. I did not know that.
BrownBoy
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks