software

I need to create a formula that displays the length of stay between to dates
in a cell. For example the length of time between date 1 = 2006/01/06 12:30
pm and date 2 = 2006/01/13 10:30 am. What is the time frame here in hours.

=A2-A1
Formatgt;Cells, Number tab, Custom. In the Type box, enter [h]
in your case the result is 166 hours

--
Kind regards,

Niek Otten

quot;Lynda Squot; lt;Lynda gt; wrote in message
...
gt;I need to create a formula that displays the length of stay between to
gt;dates
gt; in a cell. For example the length of time between date 1 = 2006/01/06
gt; 12:30
gt; pm and date 2 = 2006/01/13 10:30 am. What is the time frame here in
gt; hours.
=24(A2-A1)

format as a number.

quot;Lynda Squot; wrote:

gt; I need to create a formula that displays the length of stay between to dates
gt; in a cell. For example the length of time between date 1 = 2006/01/06 12:30
gt; pm and date 2 = 2006/01/13 10:30 am. What is the time frame here in hours.

Thank you very much. This is exactly what l was looking for

Lynda S

quot;Lynda Squot; wrote:

gt; I need to create a formula that displays the length of stay between to dates
gt; in a cell. For example the length of time between date 1 = 2006/01/06 12:30
gt; pm and date 2 = 2006/01/13 10:30 am. What is the time frame here in hours.