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

I am using excel for invoices & billing. The file name is the same as the
invoice number. how do I format a cell to do this automatically? Is there a
formula for this? and also, I also need to calculate time: say start time is
8:00am - finish time is 11:15am, is there a formula to caculate 3.25 hours?
any help will be greatly appreciated!