Excel Time Sheet For Employees

[blindmanwalks]

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/a111/blindmanwalks/exceltimesheet.pngWith
Formuals Shown -
http://i10.photobucket.com/albums/a111/blindmanwalks/exceltimesheetwithformulas.png

Any Help would be greatly appreacited. Thanks

 

[Teethless mama]

Format as: [h]:mm

 

[blindmanwalks]

Both columns F & G are set as h:mm

Format as: [h]:mm

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/a111/blindmanwalks/exceltimesheet.pngWith
Formuals Shown -
http://i10.photobucket.com/albums/a111/blindmanwalks/exceltimesheetwithformulas.png

Any Help would be greatly appreacited. Thanks

 

[blindmanwalks]

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

- john

Both columns F & G are set as h:mm

Format as: [h]:mm

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/a111/blindmanwalks/exceltimesheet.pngWith
Formuals Shown -
http://i10.photobucket.com/albums/a111/blindmanwalks/exceltimesheetwithformulas.png

Any Help would be greatly appreacited. Thanks

 

[Mike Rogers]

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

Both columns F & G are set as h:mm

Format as: [h]:mm

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/a111/blindmanwalks/exceltimesheet.pngWith
Formuals Shown -
http://i10.photobucket.com/albums/a111/blindmanwalks/exceltimesheetwithformulas.png

Any Help would be greatly appreacited. Thanks

 

[blindmanwalks]

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.

- john

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

Both columns F & G are set as h:mm

Format as: [h]:mm


:

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/a111/blindmanwalks/exceltimesheet.pngWith
Formuals Shown -
http://i10.photobucket.com/albums/a111/blindmanwalks/exceltimesheetwithformulas.png

Any Help would be greatly appreacited. Thanks

 

[Mike Rogers]

blindmanwalks

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

Mike

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.

- john

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

Both columns F & G are set as h:mm

:

Format as: [h]:mm


:

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/a111/blindmanwalks/exceltimesheet.pngWith
Formuals Shown -
http://i10.photobucket.com/albums/a111/blindmanwalks/exceltimesheetwithformulas.png

Any Help would be greatly appreacited. Thanks