I am trying to make a equation that will work to add series of time in am and pm format. Can you help me with this?
There are many different techniques inyou can use to break apart dates or times into their component parts, add or subtract dates, and figure out how much time is elapsed between two dates.
Read this free tutorial from my web site that explains how to work with adding dates and times in Excel:
I also have this FREE video tutorial that shows you how to get month names (like "September") from dates: