Time format problem


I have a time format that excel can not understand because there is no space between the time and (am/pm) ie: (9:31AM) without a space. This prevents excel from running its normal equations on this format as the default format should be like this ( 9:31 AM).

The format is an output of an app that I am supposed to export on excel and run my calculations, but because the app gives this format I can not deal with it.

Do you have any solution or recommendations for this case ?

0 Replies