Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Show time between the Two Dates

Hi All,   I am having one requirement where I need to get the time between two dates. Please find the below sample data. Where I have one column which is "Start Date".         Let's say we h...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    5 years ago

    hi  Anonymous 

    Just add a new calculate column as below:

    After Adding 4 hours = 'Table'[Start Date] + TIME(4,0,0)

    Result:

     

    Regards,

    Lin

mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

You can add the TIME function to add 4 hrs in either a calculated column or (recommended) in a measure like this one.  Use this in a table visual with your start date column, replacing AddTime with your actual table name.

 

Plus 4 hrs = MIN(AddTime[Start Date]) + TIME(4,0,0)
 
Regards,
Pat