PDA

View Full Version : How do I calculate total hours when employee didn't work a day


MsMollie
Nov 9, 2009, 06:44 AM
I have a Microsoft excel spreadsheet set up to keep track of the employees hours. The spreadsheet calculates their hours per day with no problem. However, when it comes to the total hours for the week, one the employees has worked 48 hours and its showing 11:30. I'm thinking it is because I have no value entered in on days they are off.. If that's the reason, what formula can I use to have a 0 value for time in and time out?

JBeaucaire
Nov 9, 2009, 09:46 AM
Many people forget to convert the calculated working time back to decimal values before adding up the values. Did you do that?

For instance, you subtract A1 from B1 and then multiply by 24 to get the answer in decimal format:

=(B1-A1) * 24
...formatted as General.


A B C
1 7:00 AM 12:30 PM 5.50
2 11:00 AM 5:45 PM 6.75
3 9:00 AM 7:25 PM 10.42

Click on GO ADVANCED and use the paperclip icon to upload a sample workbook showing your data... and if it's not obvious the cell where you're having problems with the total.