Create field for Video Length 1

[dcompto]

Win 7, Access 2010:
I searched this thread and googled a lot yesterday, but have not found an answer. I'm creating a database for 100+ YouTube videos created by one of my bosses and I need to include a field for video length. Would like to be able to perform calculations on the field and for them to display as the following examples:

7:01
45:30
1:04:22

Any help would be appreciated.

 

[PHV]

I'd use a float field storing the length in seconds divided by 86400.
I'd then use a format like "h:nn:ss"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

In other words, convert seconds to days.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]

 

[dcompto]

PVH, thank you for your reply.