Time values

[Jaz]

I am trying to create a simple equation that subtracts 2 time values.

For example
Cell 1 has 38 minutes and 24 seconds.
Cell 2 has 43 minutes and 20 seconds.

The difference between the 2 is 5 minutes and 4 seconds

How would I go about doing this?

How should I enter the numbers in a cell? When I enter 38:24, it makes it
into a Date and Time field.

What are my options?

Thanks,
Jasper

 

[Peo Sjoblom]

Easiest is to enter minutes and seconds as

00:38:24
00:43:20

with the values in A1 and A2

then just subtract

=A2-A1

returns 00:04:56 for me and not 00:05:04, you need to format as either
hh:mm:ss or mm:ss