#### SteveClark590

##### New Member

- Joined
- Jul 5, 2021

- Messages
- 4

- Office Version
- 365

- Platform
- Windows

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

**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 decimal-based numbers to perform functions and then is supposed to convert them back to hh:mm:ss form, but that is not happening.**

__hh:mm:ss__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.