View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Dilly Dilly is offline
external usenet poster
 
Posts: 14
Default Subtracting Dates

Am trying to subtract one date from another to get a calculated answer in
days, hours and mins. One of the dates in question is start date of
08/06/2007 08:43 with a finish date of 21/11/2007 13:00. Is their a cell
format avaible to display the answer as 166 (04:17) i.e. number of days,
hours and mins it has taken to complete this job

Any help would be appreciated