By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,619 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

Help!! Calculations

P: n/a
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

Thanks in advance.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
-----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:
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


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.