Calculate a total for "Time"

[JamesC]

Help please!

I'm creating a music catalogue in Access but have hit a problem when trying
to calculate the total playing time of all the music tracks entered.

My basic fields are 'TrackTitle', 'Artist', 'Album' and 'TrackDuration'. The
last field is entered in time as hh:nn:ss. In the Report Header, I have an
unbound cell with a control source entry of =Sum([TrackDuration]) and the
format for this is also hh:nn:ss.

And the problem: the total playing duration of the tracks I've entered so
far is actually 24h:34m:05s BUT Access is only showing 00h:34m:05s. What's
happened to the hours?

In an alternative approach, I entered the time as a Number (to five decimal
places) but the final result is no different.

Would appreciate any help available.

 

[Wayne-I-M]

Hi James

Try using the GetTimeCardTotal() shown here
http://support.microsoft.com/kb/210604

 

[JamesC]

Wayne ...

Many thanks for the very fast feedback. Will give your suggestion a try and
let you know the outcome.

JamesC

Hi James

Try using the GetTimeCardTotal() shown here
http://support.microsoft.com/kb/210604



--
Wayne
Manchester, England.

Help please!

I'm creating a music catalogue in Access but have hit a problem when trying
to calculate the total playing time of all the music tracks entered.

My basic fields are 'TrackTitle', 'Artist', 'Album' and 'TrackDuration'. The
last field is entered in time as hh:nn:ss. In the Report Header, I have an
unbound cell with a control source entry of =Sum([TrackDuration]) and the
format for this is also hh:nn:ss.

And the problem: the total playing duration of the tracks I've entered so
far is actually 24h:34m:05s BUT Access is only showing 00h:34m:05s. What's
happened to the hours?

In an alternative approach, I entered the time as a Number (to five decimal
places) but the final result is no different.

Would appreciate any help available.

 

[JamesC]

Wayne ...

Hello again; your recommendation worked perfectly.

Many thanks once more.

JamesC

Hi James

Try using the GetTimeCardTotal() shown here
http://support.microsoft.com/kb/210604



--
Wayne
Manchester, England.

Help please!

I'm creating a music catalogue in Access but have hit a problem when trying
to calculate the total playing time of all the music tracks entered.

My basic fields are 'TrackTitle', 'Artist', 'Album' and 'TrackDuration'. The
last field is entered in time as hh:nn:ss. In the Report Header, I have an
unbound cell with a control source entry of =Sum([TrackDuration]) and the
format for this is also hh:nn:ss.

And the problem: the total playing duration of the tracks I've entered so
far is actually 24h:34m:05s BUT Access is only showing 00h:34m:05s. What's
happened to the hours?

In an alternative approach, I entered the time as a Number (to five decimal
places) but the final result is no different.

Would appreciate any help available.