Hi,

Please I really need anyone's help, i was stuck on this problem. I need to create a report on call log sheet that will display the total time talk of a certain caller. I need to do this in Access script or SQL.

say, 12:01:10 + 12:00:20 + 12:00:15 should be 12:01:45

Please if you have an idea on how to do this, i really need your expertise.

Thank you and I appreciated your help.

See:

Time, adding and subtracting time (http://www.mvps.org/access/datetime/date0009.htm)

Hope this helps ...

Hi,

Please I really need anyone's help, i was stuck on this problem. I need to create a report on call log sheet that will display the total time talk of a certain caller. I need to do this in Access script or SQL.

say, 12:01:10 + 12:00:20 + 12:00:15 should be 12:01:45

Please if you have an idea on how to do this, i really need your expertise.

Thank you and I appreciated your help.

Hey Jerry,

Did a little search and found the link below that I believe may help you to solve what your trying to accomplish.

HTH,
Shane

Follow this link: http://office.microsoft.com/en-us/access/HP010984861033.aspx

say, 12:01:10 + 12:00:20 + 12:00:15 should be 12:01:45
:confused: That formula is not valid.


This is valid:
00:01:10 + 00:00:20 + 00:00:15 = 00:01:45

I think you will need to exlpin in more detail exactly what you are trying to do.

Hi,

Please I really need anyone's help, i was stuck on this problem. I need to create a report on call log sheet that will display the total time talk of a certain caller. I need to do this in Access script or SQL.

say, 12:01:10 + 12:00:20 + 12:00:15 should be 12:01:45

Please if you have an idea on how to do this, i really need your expertise.

Thank you and I appreciated your help.

I just use a Textbox with Instruction =Now() and change on the form properties Timer Interval = 1000