LinkBack URL
About LinkBacks
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]:ss
Please Login or Register to view this content.
If you want Decimal Minutes - as above but multiply result by 1440
where original entry in B2, format result cells as Number to 2 DecimalsPlease Login or Register to view this content.
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:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks