Ask Experts Questions for FREE Help !
Ask
    MsMollie's Avatar
    MsMollie Posts: 6, Reputation: 1
    New Member
    		  
    #1

    Nov 9, 2009, 06:44 AM
    How do I calculate total hours when employee didn't work a day
    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's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    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.

    Code:
       	   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.
Not your question? Ask your question View similar questions
 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

How to calculate total hours scheduled in excel spreadsheet [ 8 Answers ]

Hi, I am trying to create a schedule for my employees and at the same time being able to calculate (or forcast for myself) the total hours that will be worked. e.g. A B C D E F G H I... P 1 NAME MONDAY...

Salaried employee works 2 hours, do I get paid for 8 hours? [ 5 Answers ]

If I'm a salaried employee, and work 2 hours in the office one day, then go home sick, does my employer have to pay me for 8 hours?

Excel Total Hours Forumla Work Schedule [ 2 Answers ]

Hi, I'm having trouble figuring out how to find the total hours of a schedule for employees. Basically, the Rows are the days of the week and the columns are names, and the times fall in the middle. The problem is the a(AM) and p(PM) are necessary because it is a 24-hour store... ...

Total hours from selected records [ 1 Answers ]

I have one table and the fields are start time and end time. I'm already find working hours from stime and etime. But I want total working hours for selected records. i.e I want total hours for 10 selected records.. in msacces

How do I calculate the total cost for an employee? [ 1 Answers ]

What should be included in calculating the total cost of an employee?

View more questions Search