time in seconds

  • Thread starter Thread starter Frank
  • Start date Start date
F

Frank

Hi there,
I am struggeling with a problem.
I have two colomns with time indication hh:mm:ss. The third colomn I have a
formula which is the result of colomn D minus colomn B in format hh:mm:ss.
Now I have to change this third colomn into only seconds.
Can anyone tell me how to do this? What kind of formula do I have to put in
this third colomn so that they do not interfere with each other?
Thank you.
 
Hi Frank,

In your third column which I assume has =D-B in it
Format it as custom [ss]

HTH
Martin
 
Back
Top