Calculate difference between two date/time values

[roninn75]

Hi, please assist with the following:

i want to subtract time in [2] from [1]. the result wont be a date obviously.

any assistance would be appreciated.

[PauloH]

Hi @roninn75,

You can also use:

Calculates the fraction of the year represented by the number of whole days between two dates. Use the YEARFRAC worksheet function to identify the proportion of a whole year's benefits or obligations to assign to a specific term.

YEARFRAC(<start_date>, <end_date>, <basis>)  

https://msdn.microsoft.com/en-us/library/ee634405.aspx 

[Zubair_Muhammad]

Hi @roninn75

Try the DATEDIFF formula

https://msdn.microsoft.com/en-us/library/dn802538.aspx

DATEDIFF(<start_date>, <end_date>, <interval>)