I am trying to subtract 7 hrs from different times entered and get the
correct time. It works fine until it goes back to the prior day. How do I
get it to display correctly? I am using Excel in Office 2007. I entered
=1:18-7:00 and have a cell format of hh:mm AM/PM