Calculate time between two times

[Tresfjording]

Hi ...
Been searching, but I am doing something wrong here, but I cannot find out what.

Can anybody help me?
This is pretty basic stuff ...

[alansidman]

Can you explain your format. I don't understand what the last character represents. I get the hh:mm/ss but the last character escapes me.

[daddylonglegs]

Excel expects to have a colon between minutes and seconds, so assuming your decimal separator is a comma you could try this formula

=SUBSTITUTE(A2,".",":")-SUBSTITUTE(A1,".",":")

[Tresfjording]

Yeah I reckoned there was a format problem.

The numbers are - hours:minutes.seconds,tenth of a second

No need for dates and more than 24 hours.

[sandy666]

or maybe this

[Tresfjording]

Seems fine, until I allow for editing, the the #VALUE error comes ...
Screenshot - 28.01.2018 , 18.34.06.png

[Tresfjording]

SOLVED

Formatting error. Format must be hh:mm:ss,0

Thanks a lot folks!!

[sandy666]

file was updated, check again here