Hi, i have a cell with data format with the following: 01-01-12 09:30.
In another cell i want to extract from the previews value only the time (hours and minutes).
How can do it?
Hi, i have a cell with data format with the following: 01-01-12 09:30.
In another cell i want to extract from the previews value only the time (hours and minutes).
How can do it?
Use the MOD() function to get the decimal value from that number, then format it as TIME.
=MOD(A1, 1)
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
----------------------------------------
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Hi,
Thanks for the reply.
My excel is in my natural language and not in english, so i attached the file so you can insert the function, please.
Thank you for the help!
Can anyone give me a tip?
thanks
Hi
See the example.
1) In C3 enter the formula given earlier: =MOD(B3, 1)
2) Now select C3 and press Ctrl-F1, select the TIME number format of your choosing.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks