SUM of time values

Concluído Postado Dec 31, 2003 Pago na entrega
Concluído Pago na entrega

I am trying to read an undifined number of Time values from an access database and display the sum of all the value read.

Basically, I'm writing a small db app (using an access 2k backend) that will log time spent on an activity (a log book). Each record will have a Start Time and a Finish Time and an Elapsed Time (using the method in my first post. What I'm trying to get to is the total time spent across all entries. There may only be 20 entries in the database but then there may be 100's.

I have had a go and my testing app is in the ZIP file. The problems with my app so far are

This line: -

Total = [url removed, login to view](GetTimeSpan(CDate(dr("START")), CDate(dr("STOP"))))

Generates this exception: -

[url removed, login to view]: Object reference not set to an instance of an object.

The exception MsgBox does appear the "correct" number of times and then Total is displayed as 00:00:00 instead of 30:00:00.

Russ

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).

## Platform

.NET

.NET Engenharia MySQL PHP Arquitetura de software Teste de Software Visual Basic

ID do Projeto: #3055341

Sobre o projeto

7 propostas Projeto remoto Ativo em Jan 1, 2004

Concedido a:

aspxwarriorvw

See private message.

$7 USD em 5 dias
(7 Comentários)
0.8

7 freelancers estão ofertando em média $39 nesse trabalho

TakeRealUK

See private message.

$17 USD in 5 dias
(554 Comentários)
6.7
kdz13

See private message.

$49.3 USD in 5 dias
(74 Comentários)
6.3
s2010vw

See private message.

$17 USD in 5 dias
(8 Comentários)
5.6
yitzsl

See private message.

$12.75 USD in 5 dias
(7 Comentários)
4.6
sjhatchard

See private message.

$6.8 USD in 5 dias
(6 Comentários)
2.7
ysfred4

See private message.

$12.75 USD in 5 dias
(1 Comentário)
2.5
siteware

See private message.

$170 USD in 5 dias
(0 Comentários)
0.0