Finding number of hours between dates

[Anonymous]

How do I find the number of hours from yesterday and now ?

Lets say hours between

2015-05-17 23:59:02    and now()

I must be able to validate this formula using a textbox

[robert_mika · Accepted solution]

=(now()-'2015-05-17 23:59:02')*24

[#3]

you could also try this:

=interval(now()-'2015-05-17 23:59:02','hh')