HiI have a two calculated columnCol1 Col227-12-2019 04:35:00 28-12-2019 05:24:00Need to calculate hours between col2-col1Both column have date/time datatypeI need a total hours between the date.Thanks in advance

Hi, This calculated column formula works =DATEDIFF([Col1],[Col2],MINUTE)/60 Hope this helps.

datediff =datediff(startate,enddate, HOUR) Not hours, make sure that is correct.

Hi Greg_Deckler edhans Ashish_Mathur Sorry for my mistake. I made some mistake in calculated column.(I used both date as (start date time) for finding difference).i think its working fine. Thank you so much for all your replay

Please mark the one that finally nailed it sathyaramesh as the solution so the thread will be solved and others can see the answer easily

Hi, Try this calculated column formula =Data[Col2]-Data[Col1] Format this column as Date/Time. Hope this helps.

Calculate hours between two date/time column

21 Replies

Ashish_Mathur
Super User
6 years ago
Hi,

Try this calculated column formula

=Data[Col2]-Data[Col1]

Format this column as Date/Time.

Hope this helps.
- sathyaramesh
  Advocate II
  6 years ago
  Hi
  I need total hours between the two column
  
  Thanks
  - Ashish_Mathur
    Super User
    6 years ago
    Hi,
    
    This calculated column formula works
    
    =DATEDIFF([Col1],[Col2],MINUTE)/60
    
    Hope this helps.
v-gizhi-msft
Community Support
6 years ago
Hi,

Please try this calculated column, and this can easily reach your requirement:
Total Hour = DATEDIFF('Table'[Col 1],'Table'[Col 2],SECOND)/3600
The result shows:
If my answer has solved your issue, please mark it as a solution for others to see.
Thanks!

Best Regards,
Giotto Zhi
Greg_Deckler
Community Champion
6 years ago
Column = DATEDIFF([Col1],[Col2],HOURS)
- sathyaramesh
  Advocate II
  6 years ago
  Hi
  I tried but i have a date/time column
  If i use that formula i am getting 0 for all rows
  
  Is there any other way to calculate?
  
  Thanks