redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,604
- Office Version
- 365
- Platform
- Windows
Hello all
In a cell I have the formula
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
In a cell I have the formula
Code:
=TEXT(K7-J7,"h:mm"))
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