Datediff doesn't show half days

[HDavila]

I'm currently working on I project where I need to calculate the difference between two days to get that result and divided by the profit/loss to get the profit by day but when I use Datediff the result is not giving me the right result.

For Example:

22/3/2020 00:01	22/3/2020 19:24
3/3/2020 00:01	8/3/2020 13:12

In the example above the first line should be 0.807638888894871 but PBI is showing 0 and the second line should be 5.54930555559986 and PBI is showing 5.  I tried to see if the number was hidden but when I unhide the decimals they are 0.  I need the exact number to get an accurate result.  Can anyone help me with this issue?  

[Anonymous · Accepted solution]

To get the exact number... just subtract one date from the other.

Best
D

[niveekiwi]

What do you mean with this as I have the same question?

[HDavila]

Thank you that worked