YoMarie wrote...
....
project for a small business of creating a Time Card that will calculate
itself. The company works on a standard US clock, that begins the day at
12:01 AM and ends the day at 12:00 PM (Midnight). They have operated on this
clock for over 25 years. So I need to find a solution.

First, if you call 12:00 PM midnight, what's noon?

You'll need to use text formulas.

=IF(TEXT(DateTime,"hh:mm")="00:00",
TEXT(DateTime-1,"mm/dd/yyyy ""Midnight"""),
TEXT(DateTime,"mm/dd/yyyy hh:mm AM/PM"))