Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Two seperate dates with time stamps

I have two different dates with time stamps. I am trying to figure the hours between the two dates with the time stamp included. Do I use the same formula below except insert the time stamp and get that number and then take the difference between the two different formulas?


Digitization time is the start time and comp time is the completion time.



=-1*(DaysBetween([Derivatives Processed per Hour by Workflow].[Digitization Time];[Derivatives Processed per Hour by Workflow].[Comp Time])*86400+(ToNumber(FormatDate([Derivatives Processed per Hour by Workflow].[Digitization Time];"HH"))*3600+ToNumber(Left(FormatDate([Derivatives Processed per Hour by Workflow].[Digitization Time];"mm;ss");2))*60+ToNumber(FormatDate([Derivatives Processed per Hour by Workflow].[Digitization Time];"ss")))-(ToNumber(FormatDate([Derivatives Processed per Hour by Workflow].[Completion Full Date];"HH"))*3600+ToNumber(Left(FormatDate([Derivatives Processed per Hour by Workflow].[Completion Full Date];"mm;ss");2))*60+ToNumber(FormatDate([Derivatives Processed per Hour by Workflow].[Completion Full Date];"ss"))))

Former Member
Former Member replied

Hi, Mahboob,

It worked! thank you very much. I really appreciate it.

Thanks,

Roger

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question