How to add time (Minutes & Seconds) together to get total running time

[TraceyBennet]

Hello.

This is my first time in this forum so if I get things wrong please forgive me.

I need help with coming up with a way to add a series of time values (shown as Minutes and Seconds)
together and the closest example that I can think of would be the total running time for a CD,
For example:
Track 1 is 1 minute & 30 seconds long and Track 2 is 2 minutes and 45 seconds long, therefore
the combined playing time of both songs would be 4 minutes & 15 seconds.

I need this to be done on only a specific set of records as held in the CURRENT subform.
Allow me to explain further:

We have a main form called FrmOne and a subform called SubFrmOne. On FrmOne is a Catalogue
number field that is unique to, and refers to, all the items on the CURRENT form and subform thus
creating a linked or related set of records. The number of records contained in the subform can vary and
they also have thier own item number (Item 1,2,3 and so on) which is entered into a text box called TxtItem"
but they are all related to the main form by the catalogue number so refering to them is not hard.

For example:
We give the record in the main form "FrmOne" a catalogue number of AAAA, then any items entered in the
subform "SubFrmOne" would be sequentially numbered. Also the time I wish to add together is
entered into a text box called TxtTime as Minutes and Seconds.So if there are 5 Items in the subform
it would look like this:

(FrmOne) (Catalogue Number) (SubFrmOne) (TxtItem) (Time)
Current Record = AAAA <---related to 1 1:30
2 1:30
3 2:00
4 1:30
5 2:30

So each Item could be refered to as AAAA1, AAAA2 and so on. I need to add together the times
shown on the subform for all itmes related to Catalogue Number AAAA (in this case 09:00 mins)
and then display the total in a Text box on the main form called TxtTotalTime.

I dont mind if this is done with a query, function or some other means but I have tried to get
this to work but it is beyond my skills I am afraid.

Can anyone help me out with this please, I really would be most grateful.

Tracey Bennet

 

[SouthwestNut]

Use the DateAdd function... I think

 

[TraceyBennet]

Nope that dont work, I tried that but its minutes and seconds I want to add up.

Tracey

 

[WingandaPrayer]

Tracy,

have a look at this thread.thread705-122057


David