garywood84
New Member
- Joined
- Jan 31, 2010
- Messages
- 22
I am subtracting dates in Excel 2013. This works fine, except where the result should be 00:00 (hours:minutes), which appears as -00:00. How can I make this appear just as 00:00?
ADVERTISEMENT
Does it work if you round to the nearest minute, i.e. with this formula
=MROUND(A2-B2,"0:01")
ADVERTISEMENT
Maybe this?
=IF(A9<=TODAY(),ABS(B9-C9),"")
Note: This formula makes all date differences positive.
My suggestion within your formula will look like this
=IF(A9<=TODAY(),MROUND(B9-C9,"0:01"),"")