|
ADDING TIMES
I have a worksheet where I am having a time in and time ut calculated to
hours owrked for a week. At the end I need to add the total hours of each day for a weekly total. I have everythig working except the adding od the week, whihc is not giving me the correct answers. I have checked the formatting of all the cells, and followed the guides available in excel help, but cannot get it to work. The odd this is when I just add two days (i.e. Monday and Tuesday) it works fine. Only fouls up when I add the third day to it. example format: Semester 1 Monday Tuesday Wednesday Thursday Friday Total Hrs Week Of: In Out Hrs In Out Hrs In Out Hrs In Out Hrs In Out Hrs 8/8/2005 8:32 17:05 8:33 8:10 17:32 9:22 8:15 16:25 8:10 8:00 16:00 8:00 8:12 13:00 4:48 14:53 Thanks in advance -- John C. Harris, MPA JCZ Consulting Services, LLC |
You say you have checked the formatting, but as it goes wrong on 3 days, it
sounds like formatting. Have you formatted the result cell as [hh]:mm -- HTH Bob Phillips "John C. Harris, MPA" wrote in message ... I have a worksheet where I am having a time in and time ut calculated to hours owrked for a week. At the end I need to add the total hours of each day for a weekly total. I have everythig working except the adding od the week, whihc is not giving me the correct answers. I have checked the formatting of all the cells, and followed the guides available in excel help, but cannot get it to work. The odd this is when I just add two days (i.e. Monday and Tuesday) it works fine. Only fouls up when I add the third day to it. example format: Semester 1 Monday Tuesday Wednesday Thursday Friday Total Hrs Week Of: In Out Hrs In Out Hrs In Out Hrs In Out Hrs In Out Hrs 8/8/2005 8:32 17:05 8:33 8:10 17:32 9:22 8:15 16:25 8:10 8:00 16:00 8:00 8:12 13:00 4:48 14:53 Thanks in advance -- John C. Harris, MPA JCZ Consulting Services, LLC |
I sure did. That's why it is confusing me. Van't figure out why it is not
working. Another thing I found though: If I take the Sum formula =SUM(A1, B1, C1) and multiply it by 24, =SUM(A1, B1, C1)*24, and change the cell format to a number, I get the correct hours in decimal format (i.e. 44:33 changes to 44.6). -- John C. Harris, MPA JCZ Consulting Services, LLC "John C. Harris, MPA" wrote in message ... I have a worksheet where I am having a time in and time ut calculated to hours owrked for a week. At the end I need to add the total hours of each day for a weekly total. I have everythig working except the adding od the week, whihc is not giving me the correct answers. I have checked the formatting of all the cells, and followed the guides available in excel help, but cannot get it to work. The odd this is when I just add two days (i.e. Monday and Tuesday) it works fine. Only fouls up when I add the third day to it. example format: Semester 1 Monday Tuesday Wednesday Thursday Friday Total Hrs Week Of: In Out Hrs In Out Hrs In Out Hrs In Out Hrs In Out Hrs 8/8/2005 8:32 17:05 8:33 8:10 17:32 9:22 8:15 16:25 8:10 8:00 16:00 8:00 8:12 13:00 4:48 14:53 Thanks in advance -- John C. Harris, MPA JCZ Consulting Services, LLC |
That just proves that it has the correct calculation. Therefore, [hh]:mm
should work. I have just duplicated your data and I get 38:53 with that format. -- HTH RP (remove nothere from the email address if mailing direct) "John C. Harris, MPA" wrote in message ... I sure did. That's why it is confusing me. Van't figure out why it is not working. Another thing I found though: If I take the Sum formula =SUM(A1, B1, C1) and multiply it by 24, =SUM(A1, B1, C1)*24, and change the cell format to a number, I get the correct hours in decimal format (i.e. 44:33 changes to 44.6). -- John C. Harris, MPA JCZ Consulting Services, LLC "John C. Harris, MPA" wrote in message ... I have a worksheet where I am having a time in and time ut calculated to hours owrked for a week. At the end I need to add the total hours of each day for a weekly total. I have everythig working except the adding od the week, whihc is not giving me the correct answers. I have checked the formatting of all the cells, and followed the guides available in excel help, but cannot get it to work. The odd this is when I just add two days (i.e. Monday and Tuesday) it works fine. Only fouls up when I add the third day to it. example format: Semester 1 Monday Tuesday Wednesday Thursday Friday Total Hrs Week Of: In Out Hrs In Out Hrs In Out Hrs In Out Hrs In Out Hrs 8/8/2005 8:32 17:05 8:33 8:10 17:32 9:22 8:15 16:25 8:10 8:00 16:00 8:00 8:12 13:00 4:48 14:53 Thanks in advance -- John C. Harris, MPA JCZ Consulting Services, LLC |
I got it working. I cleared everything and re-entered formatting and it
worked. Must have been something hiding in there. Thanks for the help. -- John C. Harris, MPA JCZ Consulting Services, LLC "Bob Phillips" wrote in message ... That just proves that it has the correct calculation. Therefore, [hh]:mm should work. I have just duplicated your data and I get 38:53 with that format. -- HTH RP (remove nothere from the email address if mailing direct) "John C. Harris, MPA" wrote in message ... I sure did. That's why it is confusing me. Van't figure out why it is not working. Another thing I found though: If I take the Sum formula =SUM(A1, B1, C1) and multiply it by 24, =SUM(A1, B1, C1)*24, and change the cell format to a number, I get the correct hours in decimal format (i.e. 44:33 changes to 44.6). -- John C. Harris, MPA JCZ Consulting Services, LLC "John C. Harris, MPA" wrote in message ... I have a worksheet where I am having a time in and time ut calculated to hours owrked for a week. At the end I need to add the total hours of each day for a weekly total. I have everythig working except the adding od the week, whihc is not giving me the correct answers. I have checked the formatting of all the cells, and followed the guides available in excel help, but cannot get it to work. The odd this is when I just add two days (i.e. Monday and Tuesday) it works fine. Only fouls up when I add the third day to it. example format: Semester 1 Monday Tuesday Wednesday Thursday Friday Total Hrs Week Of: In Out Hrs In Out Hrs In Out Hrs In Out Hrs In Out Hrs 8/8/2005 8:32 17:05 8:33 8:10 17:32 9:22 8:15 16:25 8:10 8:00 16:00 8:00 8:12 13:00 4:48 14:53 Thanks in advance -- John C. Harris, MPA JCZ Consulting Services, LLC |
All I did was keep you looking <g
Bob "John C. Harris, MPA" wrote in message ... I got it working. I cleared everything and re-entered formatting and it worked. Must have been something hiding in there. Thanks for the help. -- John C. Harris, MPA JCZ Consulting Services, LLC "Bob Phillips" wrote in message ... That just proves that it has the correct calculation. Therefore, [hh]:mm should work. I have just duplicated your data and I get 38:53 with that format. -- HTH RP (remove nothere from the email address if mailing direct) "John C. Harris, MPA" wrote in message ... I sure did. That's why it is confusing me. Van't figure out why it is not working. Another thing I found though: If I take the Sum formula =SUM(A1, B1, C1) and multiply it by 24, =SUM(A1, B1, C1)*24, and change the cell format to a number, I get the correct hours in decimal format (i.e. 44:33 changes to 44.6). -- John C. Harris, MPA JCZ Consulting Services, LLC "John C. Harris, MPA" wrote in message ... I have a worksheet where I am having a time in and time ut calculated to hours owrked for a week. At the end I need to add the total hours of each day for a weekly total. I have everythig working except the adding od the week, whihc is not giving me the correct answers. I have checked the formatting of all the cells, and followed the guides available in excel help, but cannot get it to work. The odd this is when I just add two days (i.e. Monday and Tuesday) it works fine. Only fouls up when I add the third day to it. example format: Semester 1 Monday Tuesday Wednesday Thursday Friday Total Hrs Week Of: In Out Hrs In Out Hrs In Out Hrs In Out Hrs In Out Hrs 8/8/2005 8:32 17:05 8:33 8:10 17:32 9:22 8:15 16:25 8:10 8:00 16:00 8:00 8:12 13:00 4:48 14:53 Thanks in advance -- John C. Harris, MPA JCZ Consulting Services, LLC |
| All times are GMT +1. The time now is 07:21 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com