Skip to Content

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"))))

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 30, 2015 at 03:39 PM

    Hi Roger,


    Check out this discussion, I've tried it before suggesting and it works great.

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded