How do I convert negative seconds (eg. -10) into minutes in the next cell (eg -00:00:10) ?
2 Answers
If the value is in A1:
=IF(A1<0,TEXT(1-A1/24/60/60,"-HH:mm:ss"),TEXT(A1/24/60/60,"HH:mm:ss"))
Your question is unclear, you ask for minutes yet it shows it as seconds
As such, I'll keep it with seconds, it's easily updatable to minutes
I would use this
=TEXT("-00:00:"&A1*-1,"HH:mm:ss")
However, this is only for show as it's a string, I suspect Excel won't like it if you try to use it as a date object
-00:00:10
directly?)