View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joshua joshua is offline
external usenet poster
 
Posts: 25
Default Difference between date and time

I am trying to get the difference between date and time into the hh:mm format.
Example:

Start Date End Date Time taken to complete
7-1-09 8:00 AM 7-2-09 8:30 AM 24:30

How can i get it to calculate the difference between the date and the time