On Monday, 30 April 2018 04:12:35 UTC+12, GARYWC wrote:
The times are in E16 and G16 so I've changed Claus's formula to:

=TEXT(G16-E16,"h")&" hrs "&TEXT(G16-E16,"m")&" mins" formula.

When I paste that formula in C16, the result is 2 hrs 1 mins.

When I paste that formula into the other cells in column C, the result is 2 hrs 1 mins, regardless of the contents in columns E and G.

Don't paste the formula text, copy and paste the whole cell itself, to the other cells in column C, then Excel will automatically adjust the row numbers.