Please help me total hours worked per week????

  • Thread starter Thread starter feretz via AccessMonster.com
  • Start date Start date
F

feretz via AccessMonster.com

I will keep this question short as i have just about given up on this
project..

I am trying to calculate the times (hh:mm) worked during a week, and then
get the right total at the end.. eg

mon(07:30) tues(08:43) wed(08:30) thur(07:30) fri(05:50)

now if i inputed these hours in as (Time format) they would total...=14:03

if i inputed these hours in as (number format) they would total...=36.83

The actual time in hours and minutes should be.............. =38:03

I know i can get passed the 24hr by using the format [hh]using excel, but
how do i get the minutes to add one hour onto the tolal hrs when they hit
60min or above and leave the remainding minutes using ACCESS

I hope there is someone out there that can help with this problem, and i
would like to thank anyone who is willing to give it a go... ;)

If someone could could make a short working example for me i would be truly
greatful.

You can e-mail me at ( (e-mail address removed)

Fingers x ....Feretz
 
feretz via AccessMonster.com said:
I will keep this question short as i have just about given up on this
project..

I am trying to calculate the times (hh:mm) worked during a week, and then
get the right total at the end.. eg

mon(07:30) tues(08:43) wed(08:30) thur(07:30) fri(05:50)

now if i inputed these hours in as (Time format) they would total...=14:03

if i inputed these hours in as (number format) they would total...=36.83

The actual time in hours and minutes should be.............. =38:03

I know i can get passed the 24hr by using the format [hh]using excel, but
how do i get the minutes to add one hour onto the tolal hrs when they hit
60min or above and leave the remainding minutes using ACCESS

I hope there is someone out there that can help with this problem, and i
would like to thank anyone who is willing to give it a go... ;)

If someone could could make a short working example for me i would be truly
greatful.
Click to expand...

There is a fundamental issue with Time and Access. Humans will write the Time
7:30 and the Duration 7 hours and 30 minutes both as "7:30". Access has no such
dual role for this expression. To Access 7:30 *always* means 7:30 AM on
December 30, 1899.

This is further complicated by the fact that since Date/Time values are
internally stored as double-numbers one can perform "Math" on them in certain
situations and get away with it and this leads people to try to use them to
store durations. As you have found though once you cross the 24 hour barrier
things start to fall apart.

The best way to deal with durations is to store Start and End Date/Times and
then use DateDiff to determine the difference to whatever resolution you
require. Once the number of seconds, minutes, or hours is determined you can do
the math and use an expression to display the results in Days, Hours, and
Minutes.
 
Did you not read the answer I submitted yesterday to your question that
explained this??!?!?!
 
Hi there Rick B,

I am realy sorry and feel quite stupi, I must have searched for it for ages
and could not remember where i posted it (i have a memory like a fish lol)

once again, i am very sorry and thank you very much for replying to my
question....By the way where did i post it?????? 8o)

thanks feretz
 
Back
Top