-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
It would be better to keep the Hours & Hours1 columns as Double data
types instead of DateTime data types. Then all you have to do is add
the values together.
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBQDKo24echKqOuFEgEQIIwwCeO3Mvr9o4sbaWKwCsk4kyWA Qw08QAn3/S
rcgKZ4FluKjm93oYR7Cu/dFq
=S117
-----END PGP SIGNATURE-----
christian wrote:
[color=blue]
> Hi all,
>
> I'm creating a TimeSheet Database and I need to calculate two
> different set of times in one field (workedhours).Does anybody knows a
> formula that will allow me to add(Hours and Hours1)and get the result
> in (workedhours). I also need a formula where(Hours) is equal to
> (WorkedHours) because sometimes the employee just works one set of
> time.
>
> example:
>
> Start Stop Hours Start Stop Hours1
> WorkedHours
> 8:00am 03:00pm 07:00 08:00am 04:00pm 08:00[/color]
