| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
time calculation excel
?B?cGFu?= wrote in
: How can I calculate the difference of time using a formula is excel I used =text([ending]-[starting],"h:mm:ss) It works untill 23:59 after that it gives me #value Assuming your time values are entered as text in cells A1 and B1, the formula is the following. =TEXT(B1-A1,"hh:mm:ss") SEE: Microsoft Help and Support, "Calculate the difference between two times" |
|
#2
|
|||
|
|||
|
Could You do this in VBA as well?
"Gate Keeper" skrev i meddelandet news:1102771505.6f2cce9350112e5c485b3264c06f3430@t eranews... ?B?cGFu?= wrote in : How can I calculate the difference of time using a formula is excel I used =text([ending]-[starting],"h:mm:ss) It works untill 23:59 after that it gives me #value Assuming your time values are entered as text in cells A1 and B1, the formula is the following. =TEXT(B1-A1,"hh:mm:ss") SEE: Microsoft Help and Support, "Calculate the difference between two times" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| Excel 2003 - long closing time when have many add-ins installed | Excel Discussion (Misc queries) | |||
| How do I stop Excel from closing the open file each time I open a. | Setting up and Configuration of Excel | |||
| Excel - Time calculation | Excel Discussion (Misc queries) | |||
| Adding time in Excel | Excel Worksheet Functions | |||
Linear Mode
