Formula to calculate day from a series of dates and times
This might be a long shot but is there a formula to search and find a multiple entries of a job number then look for the date column and calculate the series of dates for start and finish time and also include the in and out times to create a Gantt chart?
This is all data that will be entered into a separate spreadsheet
Picture for example of the data i have to work with.
Help Article Resources
Check out the Formula Handbook template!