Sign In

Welcome Back,

Signup/Login with your account

Don't have account,

You must login to ask a question.

You must login to ask a question.

You must login to add post.

Please briefly explain why you feel this question should be reported.

Please briefly explain why you feel this answer should be reported.

Please briefly explain why you feel this user should be reported.

Search
Ask A Question
  1. Asked: December 16, 2025

    Difference between two dates in Hours

    sadhallikar@lumenore.com 🛡️ Administrator

    Hello Saurabh Please create the following formula in the Calculated Measure section of the Dashboard Designer or as a Variable in the Schema Manager. Reference Documentation: Dashboard Calculated Measures: Lumenore Help - Calculated Measures Schema Manager Variables: Lumenore Help - Variables ImplemRead more

    Hello Saurabh

    Please create the following formula in the Calculated Measure section of the Dashboard Designer or as a Variable in the Schema Manager.

    Reference Documentation:

    1. Dashboard Calculated Measures: Lumenore Help – Calculated Measures
    2. Schema Manager Variables: Lumenore Help – Variables

    Implementation Details:

    1. Navigate to the SQL section of the formula editor.
    2. Use the formula below to calculate the difference between the maximum and minimum time.
    3. This version ensures the result is a decimal value:

    TIMESTAMPDIFF( MINUTE, MIN(“InOutData”.”InOut Time”), MAX(“InOutData”.”InOut Time”) )/60

     

    See less

    • 0