Thank you so much for showing me how this can be done. I have taken on the project of teaching myself excel and I don't have to say how this has been such an enormous task. I have made a few changes to my little time tracker and so far, everything has worked out okay, except for the formula to populate the minutes into the correct category automatically like you have shown in your mock file. I have tried everything and spent so many hours on trying to get this to work in my sheet and I have hit a wall. I have attached a copy of the sheet that I'm working on. I'm trying to make it so that when I select a category, then the minutes that I spent from clock in to clock out, will automatically go into the correct place. You show how to do this in the mock file, but I just cannot seem to get that to work. If you have any suggestions on how I might be able to do this or maybe what I'm missing in the excel you sent, I would be forever grateful.
thank you again so much
Candy
Bookmarks