SteveClark590
New Member
 Joined
 Jul 5, 2021
 Messages
 4
 Office Version

 365
 Platform

 Windows
I have perused many answers to this question on this forum and other forums to no avail. I decided this forum is my best option, so here goes.
I am accumulating time duration data of a repeated event (task). Different test subjects perform the task at different speeds under varying conditions. I need to be able to analyze the data relevant to those conditions. I have been able to set the format of the columns to take a simple number (ex. 12345) and have the entry read as a hh:mm:ss time quantity (ex. 01:23:45). However, when I try to perform data analysis things get weird. I understand that Excel converts time entries to decimalbased numbers to perform functions and then is supposed to convert them back to hh:mm:ss form, but that is not happening.
The sum totals are showing up with minutes and seconds values above :59 which makes the corresponding minutes and hours values off by one.
How do I format the sums to read with a max of :59 seconds and minutes?
Excel will calculate the average (mean) of a set of data just fine because the data entries never have a value greater than :59. Not sure if this will be a problem, but how do I maintain the ≤:59 format while performing statistical analyses to find mode and median values?
Thank you for any and all help.
I am accumulating time duration data of a repeated event (task). Different test subjects perform the task at different speeds under varying conditions. I need to be able to analyze the data relevant to those conditions. I have been able to set the format of the columns to take a simple number (ex. 12345) and have the entry read as a hh:mm:ss time quantity (ex. 01:23:45). However, when I try to perform data analysis things get weird. I understand that Excel converts time entries to decimalbased numbers to perform functions and then is supposed to convert them back to hh:mm:ss form, but that is not happening.
The sum totals are showing up with minutes and seconds values above :59 which makes the corresponding minutes and hours values off by one.
How do I format the sums to read with a max of :59 seconds and minutes?
Excel will calculate the average (mean) of a set of data just fine because the data entries never have a value greater than :59. Not sure if this will be a problem, but how do I maintain the ≤:59 format while performing statistical analyses to find mode and median values?
Thank you for any and all help.