Hi,
I have a file that is already totaling needed values based on an entered date range.
Now I would like to see if a way exist to narrow it by time of day also.
One problem is the time is recorded in two columns with the AM/PM in the second column.
new.jpg
Looking at the attached file can the formula in the green box be adjusted to accept a time range being added in the red boxes?
It would still need to work even if the time range is left blank.
I'd love to know how to chart this in 8 hour increments but that is another day.
Thanks for any suggestions.
Bookmarks