Forum Discussion
Excel converting colon separated numbers to time
We use MS Excel for MS365 version 2209. We have a phone system known as 8x8. We run a report every day counting the outbound calls by our sales team. We only count the calls with a duration longer t...
Jimbo75 sent me a screenshot. I have never seen times in the formula bar of Excel displayed in different formats on the same computer - does anyone else have an explanation?
I do not have an explanation, unless the value on the left is formatted as Text and Jimbo75's version of Excel is not making that obvious (by displaying a leading tick mark in the formula bar). But it looks like someone has reformatted another part of the report content -- note the different date formatting between the two reports in lines 2 and 3.
- Thank you, everyone for your replies!
It was my long-held-theory that the programmers at 8x8.com made some obscure change to their report process. After spending several hours on the phone, where they denied such changes, they just emailed me to say that they had indeed made changes to their process!
I had to insist that they escalate the case up the ladder. Finally, it landed on the right rung.
Thanks,
Jim
