View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lynda S
 
Posts: n/a
Default formula to calulate length of time

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.