Hi everyone. I have a bi weekly time sheet I am trying to automate a bit to save time for officers for payroll (and to get away from the dreaded hand written forms).
I have everything worked out as far as figuring the time in my columns but I am having some problems one two issues I can't find a solution for.
I have everything worked out as far as figuring the time in my columns but I am having some problems one two issues I can't find a solution for.
- I am trying to populate the Schedule code, time in, and time out based on the squad. This very rarely changes so I want to be able to select, populate and change if needed. I have drop downs to keep everything uniform in the Schedule Code column, however, I don't think I can validate against the list and use a formula (like VLOOKUP) to do what I am trying to do.
- I would like to just be able to put in the military time at 1800 and it automatically convert to 18:00. (1947=19:47 and so on).