So the goal of what I'm trying to do is shown in the image attached. Basically, the user can look up a date and see how long a job lasted in hourly intervals (in a 24 hour cycle). The problem I'm having is two-fold: how do I get the 24 hour format at the bottom (as shown in the picture) to where it updates depending on the date selected and how do I get the start time/end times to show up as time elapsed. For the 2nd one, it was suggested that I do this formula ((MAX([End Datetm])- MIN([Start Datetm])) But I'm not exactly sure where to go from here. I attached the workbook and what I have so far, but any help on how to get to the final result (in the pic) would be great. I realize that this is likely a multi-step process and I'm certainly not expecting anyone to help with the entire process, but I would really appreciate just a general guidelines of how to get to where I need to go from what I have so far. Thank you so much!
Update: I attached an updated workbook. I now have a dropdown calendar where the user can select a date. I also have the difference in run time (from start to end time). The big issue I'm still having is getting the drop down calendar to update with the run times so that when you select a date off the drop down it will show you only that day's run times in hourly intervals. As of now, clicking any date on the calendar doesn't do anything. The goal, for example, is instead of seeing an elapsed total time of 3,337 for CIS on 5/23 at 12 AM (they are all 12 AM for some reason), you could click on 5/23 in the calendar and see the specific times it ran (say from 9AM to 11AM). Just to repeat, any help big and small would be very much appreciated!! And a shout out to Mavis for her help so far, thank you!