Excel Time Sheet For Employees
 

Hi All,

I am sure this is going to be simple for someone but I am coming up blank on
what to do.

I have an excel worksheet which calculates the amount of time an employee
works per day and then it adds it up for a two week pay period.
I have two columns dedicated for "In" & "Out" and then one for Daily Hours
and one for Weekly Hours. Everything was going well until you get to 24 hours
and then it sets to 0:00 and after that starts counting from 1 again.
Daily is computed by End - Start and then Weekly is computed by the
following error formula =IF(ISERR(G8+F9),"",G8+F9) - G being weekly and F
Daily Hours. When I sum it up it comes up with the correct amount of hours.
=SUM(F8:F21)*24
However, the column with the weekly hours is the one that is coming up
incorrect.

Can someone please help me. Two screen shots can be found at the links below.
Excel Sheet -
http://i10.photobucket.com/albums/a1...esheet.pngWith
Formuals Shown -
http://i10.photobucket.com/albums/a1...thformulas.png

Any Help would be greatly appreacited. Thanks

Excel Time Sheet For Employees
 

Format as: [h]:mm


"blindmanwalks" wrote:

Hi All,

I am sure this is going to be simple for someone but I am coming up blank on
what to do.

I have an excel worksheet which calculates the amount of time an employee
works per day and then it adds it up for a two week pay period.
I have two columns dedicated for "In" & "Out" and then one for Daily Hours
and one for Weekly Hours. Everything was going well until you get to 24 hours
and then it sets to 0:00 and after that starts counting from 1 again.
Daily is computed by End - Start and then Weekly is computed by the
following error formula =IF(ISERR(G8+F9),"",G8+F9) - G being weekly and F
Daily Hours. When I sum it up it comes up with the correct amount of hours.
=SUM(F8:F21)*24
However, the column with the weekly hours is the one that is coming up
incorrect.

Can someone please help me. Two screen shots can be found at the links below.
Excel Sheet -
http://i10.photobucket.com/albums/a1...esheet.pngWith
Formuals Shown -
http://i10.photobucket.com/albums/a1...thformulas.png

Any Help would be greatly appreacited. Thanks

Excel Time Sheet For Employees
 

Both columns F & G are set as h:mm

"Teethless mama" wrote:

Format as: [h]:mm


"blindmanwalks" wrote:

Hi All,

I am sure this is going to be simple for someone but I am coming up blank on
what to do.

I have an excel worksheet which calculates the amount of time an employee
works per day and then it adds it up for a two week pay period.
I have two columns dedicated for "In" & "Out" and then one for Daily Hours
and one for Weekly Hours. Everything was going well until you get to 24 hours
and then it sets to 0:00 and after that starts counting from 1 again.
Daily is computed by End - Start and then Weekly is computed by the
following error formula =IF(ISERR(G8+F9),"",G8+F9) - G being weekly and F
Daily Hours. When I sum it up it comes up with the correct amount of hours.
=SUM(F8:F21)*24
However, the column with the weekly hours is the one that is coming up
incorrect.

Can someone please help me. Two screen shots can be found at the links below.
Excel Sheet -
http://i10.photobucket.com/albums/a1...esheet.pngWith
Formuals Shown -
http://i10.photobucket.com/albums/a1...thformulas.png

Any Help would be greatly appreacited. Thanks

Excel Time Sheet For Employees
 

oh, I see what you mean. I had them set to h:mm but not [h] thanks.. Got it
now..

- john

"blindmanwalks" wrote:

Both columns F & G are set as h:mm

"Teethless mama" wrote:

Format as: [h]:mm


"blindmanwalks" wrote:

Hi All,

I am sure this is going to be simple for someone but I am coming up blank on
what to do.

I have an excel worksheet which calculates the amount of time an employee
works per day and then it adds it up for a two week pay period.
I have two columns dedicated for "In" & "Out" and then one for Daily Hours
and one for Weekly Hours. Everything was going well until you get to 24 hours
and then it sets to 0:00 and after that starts counting from 1 again.
Daily is computed by End - Start and then Weekly is computed by the
following error formula =IF(ISERR(G8+F9),"",G8+F9) - G being weekly and F
Daily Hours. When I sum it up it comes up with the correct amount of hours.
=SUM(F8:F21)*24
However, the column with the weekly hours is the one that is coming up
incorrect.

Can someone please help me. Two screen shots can be found at the links below.
Excel Sheet -
http://i10.photobucket.com/albums/a1...esheet.pngWith
Formuals Shown -
http://i10.photobucket.com/albums/a1...thformulas.png

Any Help would be greatly appreacited. Thanks

Excel Time Sheet For Employees
 

blind

You did not see the [ ] around the h. Re read the post, that is what you
need to total beyond 24 hrs.

Mike Rogers

"blindmanwalks" wrote:

Both columns F & G are set as h:mm

"Teethless mama" wrote:

Format as: [h]:mm


"blindmanwalks" wrote:

Hi All,

I am sure this is going to be simple for someone but I am coming up blank on
what to do.

I have an excel worksheet which calculates the amount of time an employee
works per day and then it adds it up for a two week pay period.
I have two columns dedicated for "In" & "Out" and then one for Daily Hours
and one for Weekly Hours. Everything was going well until you get to 24 hours
and then it sets to 0:00 and after that starts counting from 1 again.
Daily is computed by End - Start and then Weekly is computed by the
following error formula =IF(ISERR(G8+F9),"",G8+F9) - G being weekly and F
Daily Hours. When I sum it up it comes up with the correct amount of hours.
=SUM(F8:F21)*24
However, the column with the weekly hours is the one that is coming up
incorrect.

Can someone please help me. Two screen shots can be found at the links below.
Excel Sheet -
http://i10.photobucket.com/albums/a1...esheet.pngWith
Formuals Shown -
http://i10.photobucket.com/albums/a1...thformulas.png

Any Help would be greatly appreacited. Thanks

Excel Time Sheet For Employees
 

Mike,

Thanks... I seen it after I posted comment and I made mention in that in my
last post but it must not have been viewable when you posted. Thanks again
though. :D

- john

"Mike Rogers" wrote:

blind

You did not see the [ ] around the h. Re read the post, that is what you
need to total beyond 24 hrs.

Mike Rogers

"blindmanwalks" wrote:

Both columns F & G are set as h:mm

"Teethless mama" wrote:

Format as: [h]:mm


"blindmanwalks" wrote:

Hi All,

I am sure this is going to be simple for someone but I am coming up blank on
what to do.

I have an excel worksheet which calculates the amount of time an employee
works per day and then it adds it up for a two week pay period.
I have two columns dedicated for "In" & "Out" and then one for Daily Hours
and one for Weekly Hours. Everything was going well until you get to 24 hours
and then it sets to 0:00 and after that starts counting from 1 again.
Daily is computed by End - Start and then Weekly is computed by the
following error formula =IF(ISERR(G8+F9),"",G8+F9) - G being weekly and F
Daily Hours. When I sum it up it comes up with the correct amount of hours.
=SUM(F8:F21)*24
However, the column with the weekly hours is the one that is coming up
incorrect.

Can someone please help me. Two screen shots can be found at the links below.
Excel Sheet -
http://i10.photobucket.com/albums/a1...esheet.pngWith
Formuals Shown -
http://i10.photobucket.com/albums/a1...thformulas.png

Any Help would be greatly appreacited. Thanks

Excel Time Sheet For Employees
 

blindmanwalks

Must have been exactly that. Thanks for the post back.

Mike


"blindmanwalks" wrote:

Mike,

Thanks... I seen it after I posted comment and I made mention in that in my
last post but it must not have been viewable when you posted. Thanks again
though. :D

- john

"Mike Rogers" wrote:

blind

You did not see the [ ] around the h. Re read the post, that is what you
need to total beyond 24 hrs.

Mike Rogers

"blindmanwalks" wrote:

Both columns F & G are set as h:mm

"Teethless mama" wrote:

Format as: [h]:mm


"blindmanwalks" wrote:

Hi All,

I am sure this is going to be simple for someone but I am coming up blank on
what to do.

I have an excel worksheet which calculates the amount of time an employee
works per day and then it adds it up for a two week pay period.
I have two columns dedicated for "In" & "Out" and then one for Daily Hours
and one for Weekly Hours. Everything was going well until you get to 24 hours
and then it sets to 0:00 and after that starts counting from 1 again.
Daily is computed by End - Start and then Weekly is computed by the
following error formula =IF(ISERR(G8+F9),"",G8+F9) - G being weekly and F
Daily Hours. When I sum it up it comes up with the correct amount of hours.
=SUM(F8:F21)*24
However, the column with the weekly hours is the one that is coming up
incorrect.

Can someone please help me. Two screen shots can be found at the links below.
Excel Sheet -
http://i10.photobucket.com/albums/a1...esheet.pngWith
Formuals Shown -
http://i10.photobucket.com/albums/a1...thformulas.png

Any Help would be greatly appreacited. Thanks