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

Lynda S

"Lynda S" wrote:

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.