View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default excel- want to format cell formula to the file name

to do the time, do finish time minus start time, just make sure the
cell is formatted as H:MM (or possibly better, [H]:MM) - this would
show as hours and minutes. IF you actually need that and as a decimal,
then multiply the result by 60 * 24

Not sure what you mean by the first part of the question but hopefully
someone else does!