Calculating time

[Cossie]

Good morning

is it possible to calculate the time difference between two cells below even though it has time and date?

Started Date & Time Completed Date & Time
18/12/2017 16:05 18/12/2017 16:16

Thanks

 

[Marcílio_Lobão]

Cossie, Good evening.

It's a normal difference:

A1 --> Started Date & Time --> 18/12/2017 16:05

B1 --> Completed Date & Time --> 18/12/2017 16:16

C1 --> =B1-A1
Format C1 as Time --> HH:MM:SS
C1 --> 00:11:00

Is that what you want?

I hope it helps.