| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to calculate date and time
please help me in something
i have two cells: 31/10/2004 18:00 01/09/2004 07:00 i want to subtract the two cells the result i am taking is 29/02/1900 11:00 but the correct result is 29 and one month what can i do thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
| Help - Information with time and date | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Discussion (Misc queries) | |||
| Combined date time cell to separate date & time components | Excel Worksheet Functions | |||
Threaded Mode
