Converting hrs:min:sec to min only

%3CLINGO-SUB%20id%3D%22lingo-sub-1440327%22%20slang%3D%22en-US%22%3EConverting%20hrs%3Amin%3Asec%20to%20min%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1440327%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20convert%2033%3A41%3A58%20(hr%3Amin%3Asec)%20to%20min%20only.%26nbsp%3B%20Have%20tried%20using%20convert%20function%20to%20no%20avail%2C%20even%20using%20suggestion%20offered%20by%20Excel%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1440327%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1442297%22%20slang%3D%22en-US%22%3ERe%3A%20Converting%20hrs%3Amin%3Asec%20to%20min%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1442297%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F689058%22%20target%3D%22_blank%22%3E%40rcs43%3C%2FA%3E%26nbsp%3BIf%20the%20%2233%3A41%3A58%22%20is%20a%20real%20time%20reference%20(for%20example%20in%20A1)%2C%20custom%20formatted%20as%20%5Bh%5D%3Amm%3Ass%20you%20can%20use%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DA1*1440%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EIn%20case%20it%20is%20a%20text%20string%2C%20try%20this%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DLEFT(A1%2C2)*60%2BMID(A1%2C4%2C2)%2BRIGHT(A1%2C2)%2F60%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3BIn%20both%20cases%2C%20format%20the%20cell%20as%20a%20number%20after%20entering%2C%20as%20it%20will%20probably%20default%20to%20%2248527%3A12%3A00%22%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I am trying to convert 33:41:58 (hr:min:sec) to min only.  Have tried using convert function to no avail, even using suggestion offered by Excel help.

1 Reply

@rcs43 If the "33:41:58" is a real time reference (for example in A1), custom formatted as [h]:mm:ss you can use:

=A1*1440

In case it is a text string, try this:

=LEFT(A1,2)*60+MID(A1,4,2)+RIGHT(A1,2)/60

 In both cases, format the cell as a number after entering, as it will probably default to "48527:12:00"