Forum Discussion
Format for time
Dear all, i transfer my file CSV to excel but the time format is different (last colume) could you pls help me how can i change time to same format? thank you very much
Orange2045 The left-aligned values are probably text values even though they look like times. Do they contain spaces after the digits?
my original csv file has the same format as below, i openned them in the same way via excel
02/01/2024;;FMX0431;B06;;0000000186;;-5:36;;
02/01/2024;;FMX0431;B06;;0000000186;;-5:36;;
-5:36 is not a valid time in Excel...
- finally we found a solution, Instead of opening with excel format,we copied the file directly in excel file with text format. this allows hours colonne have the same format. Thank you for your reply which gave us ideas!
sorry actuelly -5:36 means 5hours 36 minutes.