Struggling with a Formula that has to do with date and time

[Tclinken]

I need a formula that has a cell which counts dwelling time in hours between: Cell A2 [=NOW() function] and [mmm dd yyyy H:mm) date format]

Example:
How long a package has been on a front door step,
in A1 [this is the date and time the package arrived], A2 [Is the =NOW() function]
I want A3 to display difference in time in hours between A2 and A1,

 

[Joe4]

Welcome to the Board!

Simply:

=A2-A1

and use this Custom Format: [hh]:mm

 

[Tclinken]

i've tried this formula and the end result is saying !VALUE!

 

[Joe4]

The bigger date/time is in cell A2, right?

It sounds maybe your value in A1 is not entered as a valid date/time, but maybe as Text instead.
What does this return?
=ISNUMBER(A1)

 

[Tclinken]

it returns with "TRUE"

 

[Joe4]

Please provide us with an example of what is in A1 that returns this error for you.

 

[Tclinken]

is the cell (A1)

is the formal for (a1)

<<< a2 using =NOW() using the same cell format.

A3 >>> i've been getting close using this formula

=IF(A1>0<A2,(A2-A1)*24,0)

but the end result is "0"

 

[Tclinken]

my pictures didn't upload please standby

 

[Joe4]

Note that if you want to post images to this site, you can use the tools mentioned in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
There is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

If you are having issues getting your formula to post, see here: https://www.mrexcel.com/forum/about-board/680917-formulas-not-appearing-completely-read.html

 

[Tclinken]

Feb 19 2018 02:15 << A1

=NOW() << A2

FALSE<< A3 (=ISNUMBER(A1)