SS said:
I AM USING THE TEMPLATE FOR TIMESHEET WITH BREAKS BUT CAN NOT UNDERSTAND HOW
MY TOTAL CAN BE 53.77 HOURS AND NOT 54.17?
I'M CONFUSED WITH THE CONVERTION TO HOURS WHEN CALCULATING CLOCKCARDS.
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
The work time is entered in hours and tenths of hours (like 5.6 hours)
so a summation of those amounts could add up to 53.77 hours (53 hours
and 0.77 of an hour). You'll need to convert the 0.77 of an hour to
minutes:
To get just the tenth of minutes do this:
Round(53.77 - Int(53.77),2) yields 0.77
To calculate the actual minutes:
60 minutes (per hour) * .77 = 46.2 minutes
You could drop the .2 minutes by just doing this:
Int(60*.77) = 46
Which makes the total formula something like this:
Int(60 * Round(SumOfMinutes-Int(SumOfMinutes),2))
P.S. Using all caps in a message indicates SHOUTING!!! - just FYI ;-)
HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBSlY/zIechKqOuFEgEQLTiQCdFcC2tXlwkb2uWolYOhYJ3Gdu5FcAoJJW
wTIERseVo8ZAS5Y9/dAmom9u
=OpK1
-----END PGP SIGNATURE-----
