I'm working on an spreadsheet that presents call center rep data for a weekly period. Times are currently stored in seconds. I'd like the data to be displayed as hh:mm:ss but over a week many reps have more than 24 hours of call activity and so it is not displaying correctly. I can force the display as a text field, but then I can't sum the values up over multiple periods or multiple reps.
Currently I'm looking at one row for display and one for calculations to get around this but am wondering if someone has a more elegant solution.
Thanks for your help!
Currently I'm looking at one row for display and one for calculations to get around this but am wondering if someone has a more elegant solution.
Thanks for your help!