excel- want to format cell formula to the file name

J

jack_mel

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!
 
A

aidan.heritage

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!
 
M

Mike McLellan

In response to your time difference query, try searching this forum for 'time
difference' - there are numerous answers to the question
 
G

Gary''s Student

If you want to put the file name into a cell, then use:

=MID(CELL("filename",Z100),FIND("[",CELL("filename",Z100),1)+1,FIND("]",CELL("filename",Z100),1)-FIND("[",CELL("filename",Z100),1)-1)

will return something like:

Book1.xls

=MID(CELL("filename",Z100),FIND("[",CELL("filename",Z100),1)+1,FIND("]",CELL("filename",Z100),1)-FIND("[",CELL("filename",Z100),1)-5)

will return

Book1
 
Top