View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default NEGATIVE HOURS (2)

xl97 SR2, Win 98 SE
that didn't work for me. Did it work for you - what version of Excel?

Unless you meant enter a positive time and have it appear as negative.
(don't see much use for that).

--
Regards,
Tom Ogilvy

"Charles " wrote in message
...
André Lavoie

Try Formating the cell with custom:
-h:mm

HTH

Charles


---
Message posted from http://www.ExcelForum.com/