https://community.sap.com/t5/application-development-and-automation-discussions/time-conversion-error-excel-to-internal-table/m-p/12394743#M1995074 <P>Values are not valid, see 00:45:83 is not a valid time! (even 23:49:60 is not valid)</P><P>Did you declare the time field of your internal table with type T ?</P><P>You don't need to use convert_time_input.</P> Tue, 20 Jul 2021 05:56:47 GMT Sandra_Rossi 2021-07-20T05:56:47Z https://community.sap.com/t5/application-development-and-automation-discussions/time-conversion-error-excel-to-internal-table/m-p/12394742#M1995073 <P><IMG class="migrated-image" src="https://community.sap.com/legacyfs/online/storage/attachments/storage/7/attachments/1958572-img-20210720-104618-compress91.jpg" /></P> <P>In excel i am adding input as 23:00:00 </P> <P>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.</P> <P>Please help.</P> Tue, 20 Jul 2021 05:29:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/time-conversion-error-excel-to-internal-table/m-p/12394742#M1995073 akshayd1998 2021-07-20T05:29:02Z https://community.sap.com/t5/application-development-and-automation-discussions/time-conversion-error-excel-to-internal-table/m-p/12394743#M1995074 <P>Values are not valid, see 00:45:83 is not a valid time! (even 23:49:60 is not valid)</P><P>Did you declare the time field of your internal table with type T ?</P><P>You don't need to use convert_time_input.</P> Tue, 20 Jul 2021 05:56:47 GMT https://community.sap.com/t5/application-development-and-automation-discussions/time-conversion-error-excel-to-internal-table/m-p/12394743#M1995074 Sandra_Rossi 2021-07-20T05:56:47Z