Quick help with excel formula

A

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
 
F

Frank Kabel

Hi
simply
=A2-A1
and format as time

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

RT

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

Rex
 
Top