template for timesheet - calculation wrong

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.

SS

SS wrote:
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/zIechKqOuFEgEQLTiQCdFcC2tXlwkb2uWolYOhYJ3Gdu5FcAoJ JW
wTIERseVo8ZAS5Y9/dAmom9u
=OpK1
-----END PGP SIGNATURE-----