Forum Discussion
The Dreaded "Duration" bug
Hi! I have today created an Excel file (from CSV) using data from our core system which deals with login/logout dates and times, and then durations based on the system usage in between. I have done...
Hi
Any duration greater 23:59:59 will be displayed as a date-time format in the formula bar.
Irritatingly this isn't "it". It's displaying date-time for (for instance) 01:27:44 and using the date in calculations based on that cell.