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