average time

[redspanna]

Hello all

In a cell I have the formula

=TEXT(K7-J7,"h:mm"))

to show a shift length in H:MM using the 'start' time in K7 and 'end' time in J7 - these are formatted using a Custom h:mm setting.

This formula is copied down over aprox 100 rows to give shift lengths of all the start/end times

Is there a formula I can use to gain the 'average' time in h:mm for all these shift lengths?
I have tried using the average but it isn't recognised as a time value as its stored as TEXT

Hope this makes sense and thanks in advance

 

[steve the fish]

Why not just do K7-J7? Formatting can be done on the cell if required.

 

[redspanna]

that will work - easy huh

thanks