Forum Discussion
is it possible to capture HH:MM from the cell in text format DD-MM-YYYY HH:MM
Hi Expertise, Need you help again. I need to capture the HH:MM from another cell DD-MM-YYYY HH:MM (text format) as below From 16-01-2026 00:30 (text format) To 24:30 (HH:MM format) Regards L...
Yes, you can capture the HH:MM portion from a text string like 16-01-2026 00:30.
If the format is always DD-MM-YYYY HH:MM, use: =RIGHT(A1,5) This will return 00:30.
If you’re on Excel 365 or newer, a cleaner option is: =TEXTAFTER(A1," ") This extracts everything after the space.
Important: Excel’s time system only goes up to 23:59. If you need to display 24:30 exactly as written, you’ll need to keep it as text (using RIGHT or TEXTAFTER). If you convert it to a real time value, Excel will roll it over to 00:30 of the next day.