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 ?
|