Forum Discussion

abodqm's avatar
abodqm
Regular Visitor
2 years ago
Solved

using Datedif to see time differ between PM AM

hello guys i need help i have this begin and end time between pm and am 

and in datedif it shows negative i want it to calculate it right not show negative as shown below because time related to days as you know

 

this is my code 

 

Differ between begin and end = DATEDIFF('Sheet1 (2)'[begin date],'Sheet1 (2)'[end date],MINUTE)
 
any suggestion how to make it read it right with with PM AM ???
 

 

Need Help