I need please a formula that will achieve the following result for the time range provided below:

If cell K60 sum time value is less than 62:24 = 0
62:24-67:00 = 1121
67:01-70:54 = 1682
70:55-74:48 = 2524
74:49-78:00 = 3365
Above 78:00 = 4207

Example:
If cell K60 sum time value is 73:01, needed formula result should be 2524.[/B][/B]