Thankyou

"Pank" wrote:

Steved

Assume that the first time (i.e. 7:58 and 12:55) is is A1,A2 and the end
times are in B1, B2.

Firstly format the columns to be TIME and in a 24 hour clock format.

Then in C1 enter =b1-a1. Then either copy the formula down as far as you
want or use the FILL handle to copy down.

HTH

Pank


"Steved" wrote:

Hello from Steved

7.58 from 8.15 is 17 minutes
12.55 from 1.15 is 20 minutes

Could I please have a formula for the above please.

Thankyou.