title: Midnight as 24:00 not 00:00 in Excel
body: <p>Ok this isn't explicitly a programming question but maybe I can get around it with VBA.</p>
  
  <p>I have some times I'm working with that go over midnight and Excel is not displaying them because they would be 'negative values'. 
  Eg: 00:30 - 23:30 (or 12:30 am - 11:30pm). This is causing many errors.</p>
  
  <p>Is there a way to get around this? I've tried changing the format to [hh]:mm:ss and this doesn't help. I've also changed the time format to 1904 but this causes problems with other errors I'm using.</p>
  
  <p>Any help is appreciated!</p>