Forum Discussion
alexx1202
Jun 10, 2023Copper Contributor
Need to change date/time format on 2 columns of data
How do I format the date and time shown in the columns boxed in red to display like the one boxed in green? (Refer to pics) I want both columns to look like e.g 24/11/2009 9:32:00 PM not 2009.11...
Riny_van_Eekelen
Jun 10, 2023Platinum Contributor
alexx1202 Which Excel version are you on? Perhaps you need to advance to step 3 in Text-to-columns and specify that it's a Date in the DMY format.
alexx1202
Jun 10, 2023Copper Contributor
Thanks Riny_van_Eekelen
How do I change these cells showing time durations in 0.0 format to a 00:00 one that reads as months : weeks : days : hours ; minutes : seconds?
I can get dd : hh : mm : ss but some cells show durations over 30 days (1 month). When that happens the clock resets e.g. 32 days gets displayed as 02:00:00:00.
- Riny_van_EekelenJun 10, 2023Platinum Contributor
alexx1202 I never came across this issue but I Googled a bit and found the answer to your question in the link below: