This is possibly a really daft question which I’m hoping someone knows the answer to.
I’m looking to add up the time spent in some of the courses last month. When I export the report the times show up like this ‘0h 20m’ or ‘2s’ they are stored as text in the excel file and as such I can’t add them up. I’ve tried a few Excel codes but because it doesn’t always show h:m:s they haven’t worked. Also I want this to be fast not having to find and remove all the s, m or h’s when I split the cells.
Someone must be using something to find out how long users have been on courses. I can’t imagine I’m the only one. I might be making this a lot harder than it actually is.
Best answer by lrnlabView original