Export to csv with hours and minutes

Movies CLZ Movies Web
1

Don’t know if okay to ask a subsequent question here or I should raise a new query?

The August answer solved my question. However when trialling an export of my Movie Databse to CSV/TXT, the length of a Movie is exported as minutes. Is there any way that the export can show as in the Database, hours & minutes? Have been also trying to find a way to format the column in excel but just get 00:00:00

2

I’ve split of your question as I feel it is a bit… different :slight_smile: .

It is not possible to tell the export to export as Hours/Minutes. It will always be minutes.

However: seeing that you use Excel, I recommend just creating an extra column, and in there use

=CONVERT(A1,”min”,”hr”)

That should convert the number into a format that might work for you?