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"
|