Hi
im trying to import an Ascii file whose time format is
20:00
00:00
04:00
08:00
12:00
16:00
etc....
none of the time formats that i can choose from seem to match and i cant import it, any ideas please ?
Thankyou
Size:
Color:
H:mm should work, but you can type in HH:mm if you like. The problem is more likely that you have to add a separate Time field and move it below the Date in the Field Order list.
Size:
Color:
As Robert have just said, HH:mm is
the way to go here:
Custom Date and Time Format Strings in MSDN
H represents the hour as a number from 0 through 23, while HH represents the hour as a number from 00 through 23.
Size:
Color:
Thankyou both for the reply, i have been able to add it now
Size:
Color: