Format of time in Excel

[Petrolene]

Hi, I've integrated an excel sheet with BulkSMS which sends race results to athletes, once they've completed the race. However, the format of the time is not correct in the SMS. The format in excel is TIME,

But, once I receive the SMS, this is what the format looks like:

What should the format be in the excel sheet for the message to show the event results as is?

Thanks!
Petrolene

 

[ArshilAhmad]

Hi @Petrolene,

Please try changing the format of your Time column to 'Text' and see if that resolves the issue for you.

 

[Petrolene]

Thanks

Hi @Petrolene,

Please try changing the format of your Time column to 'Text' and see if that resolves the issue for you.View attachment 41145

Hi, no it doesn't - it gives me a text format in excel which is not what I want in the text message.

 

[ArshilAhmad]

Change the format of the column first, and then enter the time.

 

[Petrolene]

Change the format of the column first, and then enter the time.

Oh! I see what you mean. Will try that, thanks.