Hi guys,
I need urgently help.
I have this worksheet with a column which i have had standarized to be insert values less or equal to 100 and have it back as hours, but now i need values less or equal to 1000, and it to return as hours.
eg. if i insert 1000, it will be 1000:00
please check the CODE and the file
Please Login or Register to view this content.
The macro is working fine for your need.
All you have to do is to change data validation.
You have it set now to be between 0 and 100 while in new situation it shall be between 0 and 1000.
Best Regards,
Kaper
So Ctrl+G
B5:B10005
Data validation (from Data Tools group in Data card)
set to be between 0 and 1000 (as it is already done in B8)
The problem is:
If i want to get a 1000 hour, i don't get it.
did you test it?
if I type 1000 to get 1000:00 (this is hours), i get 0:60000.
but i want hours for numbers greater than 166 up to 1000.
please run some test
Last edited by Isaacadete; 11-10-2015 at 08:34 AM.
OK. I did a test before, but apparently I tested only something like 150, and of course it worked.
Here is a corrected macro part:
This change + data validation change should do the job.Please Login or Register to view this content.
PS. To achieve smoother response you could switch of screen updating during macro run , for instance here:
Please Login or Register to view this content.
thank you so much, for fixing it.
working perfectly.
but i still having the back view as date, but i have already understand that excel doesn't count time for more than 23 hours, more than that i will count as days and hours.
Because i wanted to have as well as 250:00 instead of 10/01/1900 10:00:00.
Originally Posted by Kaper
PS. To achieve smoother response you could switch of screen updating during macro run , for instance here:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks