Hi ,
I have an auto generated excel from an attendance application in which In time and out time of every employee is mentioned. Now the problem is I need to find average of In time for every employee.
The format of cells in generated file is general and the content is left indented so when i select a range I don't get the average in the bottom bar. But when I double click or press F2 the format changes to custom(hh:mm) and the text becomes right aligned now it shows the average.
I have tried converting all the cell format to hh:mm but it doesn't work so I have to manually select every cell and press f2 to find the average.
anyway I can avoid this tedious process?
TIA
I have an auto generated excel from an attendance application in which In time and out time of every employee is mentioned. Now the problem is I need to find average of In time for every employee.
The format of cells in generated file is general and the content is left indented so when i select a range I don't get the average in the bottom bar. But when I double click or press F2 the format changes to custom(hh:mm) and the text becomes right aligned now it shows the average.
I have tried converting all the cell format to hh:mm but it doesn't work so I have to manually select every cell and press f2 to find the average.
anyway I can avoid this tedious process?
TIA