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

    Nov 24, 2011, 03:04 AM
    Excel for total hours?
    Hi, I'm trying to make a formula for the total hours if time in and time out,
    JBeaucaire's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
    		  
    #2

    Nov 24, 2011, 07:46 AM
    A1: Time In
    B1: Time Out

    C1: =(B1-A1)*24 (format this cell as General)


    If you will ever have an instance where someone clocks in on one day and out early the next day, like a shift that runs from 11pm-8am, then the formula will need to be longer to take that into account:

    =((B1-A1)+(A1>B1))*24
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...

How to calculate total hours from a given time in excel [ 1 Answers ]

How to calculate the total hours worked from the excel with the help of in time and out time

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

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

View more questions Search