how to add time in access?

[jerry28ph]

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.

 

[HiTechCoach]

See:

Time, adding and subtracting time

Hope this helps ...

 

[ShaneMan]

Re: need to add time in report

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

 

[HiTechCoach]

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

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.

 

[heman85]

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