View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Negative time values

You coudl *cheat* and display the number as a regular number, and manipulate
the number to properly display minutes.

Setting the cell format to number, you could use this formula:
=("4:55"-"5:00")*1440

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"General Patton" wrote:

How do I write a formula that will calculate negative time values, i.e., 5:00
- 4:55 = -5 ?