"Jeff" wrote...
....
How about this then to help keep the complication down for someone. Since i
am going to have a colum marked as am and pm is it somehow possible to
automatically conocate the "AM" and "PM" on to the entered times either in
the same column that they enter these values or possibly in a hidden column
that I could base the formula off of?
....

If you have 12 hour clock hour/minute entries in columns B and E, and
AM/PM entries in columns C and F corresponding to entries in B and E,
respectively, and you wanted to calculate time worked in column H, try
this for row 3.

H3:
=(TEXT(E3,"h:mm ")&F3)-(TEXT(B3,"h:mm ")&C3)