I am trying to average mintues and seconds and I keep getting the #DIV/0 error and I know the cells that I am using are not at zero. Example 660:00, 134:50, 438:00. How do I format the cell so that it averages them correctly?
2007-10-31 02:11:35 · 2 answers · asked by Bean 1 in Computers & Internet ➔ Other - Computers
For time you have to translate it into something, like amount of total minutes.. then translate those back into a time. I have tried for ever to get excel to calculate times but it doesn't work becuse it is in 60's.
Maybe a newer version has it and maybe someone else will have a the answer...
But for now that is what I Suggest
2007-10-31 02:22:05 · answer #1 · answered by Carrie 5 · 0⤊ 0⤋
If you are using Excel, try the cell format ' [h]:mm:ss ', for the cells containing data you wish to average, this should work.
2007-10-31 09:20:53 · answer #2 · answered by Wayne G 3 · 0⤊ 0⤋