Hi,
in one collumn i have different time values (hr, min, sec ...), which id like to convert to the same- to have all in minutes. How can i do that..? Im sending picture what it looks like...
Thank you.
IB
Hi,
in one collumn i have different time values (hr, min, sec ...), which id like to convert to the same- to have all in minutes. How can i do that..? Im sending picture what it looks like...
Thank you.
IB
Sample Excel files are generally better than images - also it helps if you detail some expected results - it's not clear if you want the results as Time values or as Decimal minutes ?
If you want result as genuine Time value
where original entry in B2, format result cells as [m]:ssC2: =LEFT(B2;FIND(" ";B2)-1)/VLOOKUP(REPLACE(B2;1;FIND(" ";B2);"");{"sec"\86400;"min"\1440;"hr"\24};2;0) copied down
If you want Decimal Minutes - as above but multiply result by 1440
where original entry in B2, format result cells as Number to 2 DecimalsC2: =(LEFT(B2;FIND(" ";B2)-1)/VLOOKUP(REPLACE(B2;1;FIND(" ";B2);"");{"sec"\86400;"min"\1440;"hr"\24};2;0))*1440 copied down
Above is assuming Slovak configuration re: delimiters
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Or use a macro for the whole range:
Sub snb() [B1:B100] = [if(A1:A100="","",left(A1:A100,find(" ",A1:A100)-1)*choose(find(right(A1:A100,1),"rnc"),60,1,1/60))] End Sub
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks