Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Time conversion error (excel to internal table)

akshayd1998
Participant
0 Likes
794

In excel i am adding input as 23:00:00

But while passing it through fm text_convert_xls_to_sap and convert_time_input i am getting output as 22:59:60 in internal table.

Please help.

1 REPLY 1
Read only

Sandra_Rossi
Active Contributor
0 Likes
715

Values are not valid, see 00:45:83 is not a valid time! (even 23:49:60 is not valid)

Did you declare the time field of your internal table with type T ?

You don't need to use convert_time_input.