Looking for the formula

[Hickman156]

I need help finding a formula to covert a cell containing

0 days 0 hours -5 minutes

Into just 5 or 5:00 M:SS

 

[rowebca]

Hi,

Can you post an exact format to be converted , like a screenshot ?

Regards,
GB

 

[Hickman156]

Hi,

Can you post an exact format to be converted , like a screenshot ?

Regards,
GB

Those are two different ones. I need the top one to equal 6 and the bottom one to equal 2.

 

[rowebca]

So if will be something like this:

1 days 2 hours 15 minutes

What will be the conversion, and second what is the "-" sign in the front of minutes?

Regards,
GB

 

[Scott Huish]

Book1
	A	B
1	0 days 0 hours -6 minutes	6
2	0 days 0 hours -2 minutes	2
Sheet1

Cell Formulas
Range	Formula
B1:B2	B1	=-TEXTBEFORE(TEXTAFTER(A1," ",-2)," ")

 

[Hickman156]

Book1
	A	B
1	0 days 0 hours -6 minutes	6
2	0 days 0 hours -2 minutes	2
Sheet1

Cell Formulas
Range	Formula
B1:B2	B1	=-TEXTBEFORE(TEXTAFTER(A1," ",-2)," ")

THANKS! That worked great.

 

[Hickman156]

So if will be something like this:


What will be the conversion, and second what is the "-" sign in the front of minutes?

Regards,
GB

Thanks for looking at it. Scott gave me the answer.

 

[rowebca]

THANKS! That worked great.

Thanks for looking at it. Scott gave me the answer.

No problem, I thought you need a more complex function.

Regards,
GB