Date Time difference in decimal

[Yash7]

How can I get the difference between two date/time values in a decimal format. 

So 11/06/2024 06:34 - 10/06/2024 07:51 should be 0.95 difference 

[lennart_mo · Accepted solution]

Hi @Yash7,

just use the num()-function, so your formula should look something like this:

=num( YourTimestamp1 - YourTimestamp2 )

[Yash7 · Accepted solution]

Thank you so much, that works!