MrRadio915
New Member
- Joined
- Dec 20, 2005
- Messages
- 24
I've been using Excel to graph aggregate listening hours for our radio station www.am91.org. The time format that has worked until this month has been hhhh:mm:ss and the graph has worked well... until this month when the number of listening hours went above 10000.
Using 4 digit hours, Excel converted the time to a standard serial date. I doesn't work with 5-digit hours.
I've tried to convert using =hours(c2)+(minutes(c2)/60)+(seconds(c2)/3600) and it worked for the 4 digit hours but not for the 5 digit.
Other than breaking up the cells into individual cells, I'm at a loss...
Using 4 digit hours, Excel converted the time to a standard serial date. I doesn't work with 5-digit hours.
I've tried to convert using =hours(c2)+(minutes(c2)/60)+(seconds(c2)/3600) and it worked for the 4 digit hours but not for the 5 digit.
Other than breaking up the cells into individual cells, I'm at a loss...