View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Igor Igor is offline
external usenet poster
 
Posts: 20
Default Number of hours between now and selected date

I need a formula to calculate number of hours between data and time set in
the cell by function NOW() and a set date in the same format:

Example:

NOW() - return 29/07/2009 16:06:00
set date - 07/08/2009 06:00:00
result to be difference between the dates presented in hours