I have a column that has date and time combined but I need to separate out only the time. I was going to use "text to columns" but the date is not standard (Jan appears as 1, not 01)
thanks for the help
1 file attached
I have a column that has date and time combined but I need to separate out only the time. I was going to use "text to columns" but the date is not standard (Jan appears as 1, not 01)
thanks for the help
1 file attached
You can use MOD
B1: =MOD(A1,1)
or conversely
B1: =A1-INT(A1)
(ie subtract the date integer from the value to leave incomplete days value)
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks