ExcelBanter - time calculation excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - time calculation excel (https://www.excelbanter.com/excel-worksheet-functions/7798-re-time-calculation-excel.html)

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"

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"