https://community.sap.com/t5/technology-q-a/difference-between-two-timestamps-in-sap-analytics-cloud/qaa-p/11896874#M4467393 <P>Nobody ever done this before? How to calculate the difference between two time stamps. Seems rather important: how long has croissant been in the oven, how many hours has someone worked...</P><P>Those questions I need to solve in SAP Analytics Cloud on data import model.</P><P>Tx,</P><P>Jan</P> Thu, 23 Jan 2020 10:31:13 GMT ironjan 2020-01-23T10:31:13Z https://community.sap.com/t5/technology-q-a/difference-between-two-timestamps-in-sap-analytics-cloud/qaq-p/11896873 <P>Hi, </P> <P>I need to calculate the difference between two timestamps in a model in SAP Analytics Cloud. </P> <P>For context, during data import, I set some columns to "Timestamp" as the hour and minute information is important and will be discarded if imported as "Date". I know that there is a DATEDIFF function available to calculate the difference between two dates. Is a similar function available for timestamps? Currently, it does not seem like the DATEDIFF function is applicable to timestamps.</P> <P>I appreciate your help!</P> Tue, 02 Jul 2019 16:10:16 GMT https://community.sap.com/t5/technology-q-a/difference-between-two-timestamps-in-sap-analytics-cloud/qaq-p/11896873 Former Member 2019-07-02T16:10:16Z https://community.sap.com/t5/technology-q-a/difference-between-two-timestamps-in-sap-analytics-cloud/qaa-p/11896874#M4467393 <P>Nobody ever done this before? How to calculate the difference between two time stamps. Seems rather important: how long has croissant been in the oven, how many hours has someone worked...</P><P>Those questions I need to solve in SAP Analytics Cloud on data import model.</P><P>Tx,</P><P>Jan</P> Thu, 23 Jan 2020 10:31:13 GMT https://community.sap.com/t5/technology-q-a/difference-between-two-timestamps-in-sap-analytics-cloud/qaa-p/11896874#M4467393 ironjan 2020-01-23T10:31:13Z