Quick help with excel formula

[ABC_BOXER]

Ok, i need a forumla.

this is what I want, i have two columns like this

Time Start: .............
Time Finish: ............

I fill out these two columns like this

Time Start: ...17:42...
Time Finish: ...18:25..

Now i have another Column that says

Training Length: ........

I want this to work out the time between 17:42 and 18:25

Any one help pleas

 

[Frank Kabel]

Hi
simply
=A2-A1
and format as time

If your training time can span midnight use the formula
=A2-A1+(A2<A1)

 

[Don Guillett]

Have you tried subtracting one from the other?

 

[RT]

Don't forget to put hh between [] otherwise it will not count more than 24
hours

Rex