Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
time in seconds
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. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
time in seconds
Hi Frank,
In your third column which I assume has =D-B in it Format it as custom [ss] HTH Martin "Frank" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Time with minutes and seconds | Excel Discussion (Misc queries) | |||
How to convert time into seconds. | Excel Discussion (Misc queries) | |||
how do i add seconds (time)? | Excel Worksheet Functions | |||
Convert "Time Interval" in "hours : minutes : seconds" to seconds | New Users to Excel | |||
Convert time to all seconds | Excel Discussion (Misc queries) |