https://community.sap.com/t5/technology-q-a/adding-hhmm-to-a-date/qaa-p/12047097#M4502191 <P>use below to convert string to date.</P><P>=todate([Date HHMM object];"hh:mm")</P> Mon, 23 Sep 2019 10:36:30 GMT amitrathi239 2019-09-23T10:36:30Z https://community.sap.com/t5/technology-q-a/adding-hhmm-to-a-date/qaq-p/12047096 <P>1. Convert hhmm to hh:mm (should be a time format)</P> <P>2. Need a working formula to add hhmm(string) to a date(string) - DateTime1 variable</P> <P>2. Add additional time(like 4, 5, 8 hours) to DateTime1 variable </P> Fri, 20 Sep 2019 19:45:59 GMT https://community.sap.com/t5/technology-q-a/adding-hhmm-to-a-date/qaq-p/12047096 Former Member 2019-09-20T19:45:59Z https://community.sap.com/t5/technology-q-a/adding-hhmm-to-a-date/qaa-p/12047097#M4502191 <P>use below to convert string to date.</P><P>=todate([Date HHMM object];"hh:mm")</P> Mon, 23 Sep 2019 10:36:30 GMT https://community.sap.com/t5/technology-q-a/adding-hhmm-to-a-date/qaa-p/12047097#M4502191 amitrathi239 2019-09-23T10:36:30Z