How to limit time values outputted in certain cell

[vintage36]

A B C

1 07:09 08:30 01:21

2 06:43 08:30 01:47

3 05:29 08:30 03:01

Cols A and B above represent times entered in a spreadsheet with the interval between, e.g. A1 – B1 = C1.

However, any result in Col C must not exceed 02:00 (2 hours).

I need a formula I can apply to the whole of Col C to ensure the condition is obeyed throughout.

Please: are you able to advise?

Kindly ignore the the below attachment

 

[Momentman]

Something like this

Get Sheet Names.xlsx
	A	B	C
1	7:09	8:30	01:21
2	6:43	8:30	01:47
3	5:29	8:30	02:00
Sheet2

Cell Formulas
Range	Formula
C1:C3	C1	=MIN(120/1440,B1-A1)

 

[vintage36]

thanks:0