aaron_brown99
New Member
- Joined
- Mar 31, 2002
- Messages
- 20
I've seen this issue on the board, but the answers so far aren't working for me.
I have a spreadsheet which lists times in minutes and seconds measuring the time an agent is on a call with a customer. The file was output in excel format, but the time field is formatted as general.
When I change the format to mm:ss AND RECALCULATE THE SHEET, the values don't change to the correct format. If I apply a SUM function, it reads as 00:00. Only by double-clicking each cell can I get the value to actually switch format and work in calculations.
I MUST be doing something wrong, I hope. Can anyone advise me?
I have a spreadsheet which lists times in minutes and seconds measuring the time an agent is on a call with a customer. The file was output in excel format, but the time field is formatted as general.
When I change the format to mm:ss AND RECALCULATE THE SHEET, the values don't change to the correct format. If I apply a SUM function, it reads as 00:00. Only by double-clicking each cell can I get the value to actually switch format and work in calculations.
I MUST be doing something wrong, I hope. Can anyone advise me?