Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
Asked previously...can this not be done in excel | Excel Discussion (Misc queries) | |||
Excel Time Sheet - Rounding To Quarter Hours | Excel Worksheet Functions | |||
Does excel recognise names rather than cells? | Excel Worksheet Functions | |||
I need an Excel bi-weekly employee time sheet template | Excel Discussion (Misc queries) |