Formula Field to calculate hours from Date Time field in Salesforce

Hey there, This is sample formula field to get difference in hours from date time field to current time.

I have considered Event standard field ActivityDateTime to calculate hours in this example

See formula below screenshot.

formula:

	(FLOOR(( NOW() - ActivityDateTime)*24))
	+
	FLOOR((((
	((NOW() - ActivityDateTime )*24)-
	FLOOR((NOW() - ActivityDateTime)*24))
	*60)/100))

view raw sampleFormulaHours.java hosted with ❤ by GitHub