Date format of New Analytics lateAssignment report not interpretted by Excel correctly
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
4 hours ago
Hi Everyone,
One of our school admin team contacted us. She noticed that the New Analytics>LateAssignments reporting generates a time/date format that our setup of Excel does not immediately recognise.
E.g. this is the result:
| Submitted Date | Graded Date | Posted Date | |
| 11:59.0 | 19:14.5 | 39:22.1 | |
| 11:50.0 | 54:55.2 |
From a CSV file where the first row is written as:
2024-12-16 14:11:59.000,2024-12-23 00:19:14.506,2025-01-10 14:39:22.091
(which seems pretty standard apparently)
It's relatively easy to use Excel's 'Text to Columns' feature for the tech savvy, but wondered if other people had also found this (I'm using UK machines so always wary of regional differences)?
Thanks, Will (Liverpool, UK)
