| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text to date then subtract...
Yet another answer. Use this formula (same end result as Dave O's formula; a
number excel can interpret as date and time) =VALUE(TEXT(B1,"####-##-## ##\:##\:##"))-VALUE(TEXT(A1,"####-##-## ##\:##\:##")) and format the cell as [s] to show only seconds. "ryan" wrote: Hello all, Time to ask the experts, I'm completly lost! I've got two text fields that are actually dates & times: A1 = 20030715085639 B1 = 20030715085707 I need the difference in seconds between the two ... in this example 28. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert Text to DATE | Excel Discussion (Misc queries) | |||
| converting text in cell to a date time | Excel Worksheet Functions | |||
| Subtract text in one cell from another? | Excel Worksheet Functions | |||
| Macro to convert text to date | Excel Worksheet Functions | |||
| EXTRACT TEXT FROM A DATE | Excel Worksheet Functions | |||
Threaded Mode
