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

    Jul 10, 2010, 05:24 PM
    How to calculate total hours from a given time in excel
    How to calculate the total hours worked from the excel with the help of in time and out time
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Jul 11, 2010, 08:54 AM

    A2 - TIME IN (in Excel time format: 8:00 AM)
    B2 - TIME OUT (in Excel time format: 4:30 PM)
    C2: =(B2 - A2) * 24 (formatted as General or Number)

    If you have to deal with shifts that go past midnight, you have to check for that.

    C2: =((B2-A2) + (A2>B2)) * 24

    Sample attached.
    Attached Files
  1. File Type: xls SimpleTime.xls (13.5 KB, 287 views)
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...

Calculate the total cost of the job using machine hours as the allocation base [ 1 Answers ]

ABC Corporation manufactured a new electronic part for Apple’s new cell phone. In particular, it manufactured 100,000 of these parts for Apple’s order. ABC wants to calculate the job cost and the cost per part. For this particular job, direct materials were $250,000 and direct labor was...

Calculate the total cost of the job using direct labor hours as the allocation base? [ 0 Answers ]

ABC Corporation manufactured a new electronic part for Apple’s new cell phone. In particular, it manufactured 100,000 of these parts for Apple’s order. ABC wants to calculate the job cost and the cost per part. For this particular job, direct materials were $250,000 and direct labor was...

How do I calculate total hours when employee didn't work a day [ 1 Answers ]

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...

Excel Time Sheet - Error in calculating total hours [ 2 Answers ]

I have this set up pretty basically, I believe. Column C are the days of the week, Column D is the date, Column E is the time clocked in, Column F is the time clocked out and Column G are the total hours worked for that day. In G18, I've set up (or so I think) the formula to calculate this...

View more questions Search