I consider myself a just above basic excel user, I don't use it on a regular basis and I tend to search to find out formulas etc on how to do something.
However my challenge is to collect some Data from lots of different users of differing skill levels over multiple sites using different versions of excel.
I need to get them to record the time they spend using a in house computer system.
To try and make it easier and actually get the data needed I created a couple of lists of hours:minutes for them to pick for start time, finish time and then a simple calculation in the next column to work out time spent and sum it at the bottom.
Is there a way to make the second column drop down list of finish time jump so it shows the list from where they have listed their start time?
I am not sure how to search for an answer? or is there a better way of simplifying it?
Also is there a way of inserting a calendar so they can just pick the date? I can't set it as today as they won't necessarily be entering the data each day. Or is it an add on that won't work with different versions of excel.
The file has five sheets as times are recorded onto different sheets depending on what level they are and an additional one for when they are working outside of normal hours, so the dropdown list is a lot longer for that sheet.
Also for the managers to see what is happening I have created a summary sheet at the front that pulls the data from the different sheets to the front so they can see how much time has been spent for that week working on the system.
But they would also like to see a comparison from the week before and a running total of the current month, so is there a formula I can use to sort and add up the times based on a date range?
Thank you for any info
Bookmarks