Hi,
In Cell A1 I have the date. In Cell B1 is the shift. There are three shifts labeled as 1, 2, and 3. Is it possible to create a rule that will convert 1 to 0700, 2 to 1500, and 3 to 2300? Below is an example of how I need the shifts converted to time (military).
Please Login or Register to view this content.
make a table with the data
e.g. H1:I3
1 0700
2 1500
3 2300
Then use VLookup to find the data in the table.
c1=vlookup($b1,$h$1:$i$3,2,0)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi oeldere,
Thanks for your reply. Is there a way to create a custom rule that will automatically convert the shift to a time?
You mean that the content of the cell in which you add the shift automatic will change?
That is not possible with excel; it is possible with VBA.
It can be done without an table, if that is your question.
But I would solve it, for the flexibility, with an table.
Thank you very much oeldere, you have answered my question.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks