How To Do Time Calculation In Excel Of The Work Hours?

Asked By alber sontie 0 points N/A Posted on - 04/28/2017

How do I do the time calculation in excel of the work hours of a job or a shift in the job. I have some data to form like this. Please, help.

• Status: Open
• Question Views: 271
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: OS
• Question Tags: calculation | Excel

Answered By Diego Lee 10 points N/A #295779

How To Do Time Calculation In Excel Of The Work Hours?

Using the three cells, A1, B1, and C1 we will perform the calculations.

The cell which will store the Time of coming in is A1, which store the time of going out is B1, and which store the actual difference or the working hours is C1.

Now we select the A2 and B2 cells and press the CTRL key to open up the format cells dialog box.

Go to the number tab and select time from the category list box and choose 1:30 PM and click OK.

Then go to C2 and open the format cells.

On the number tab, choose 13:30 this time and click OK.

And then in C2 enter the formula given here,

=IF(B2<A2,B2+1,B2)-A2

Now you can enter any time and get the correct result.

About Diego Lee

Questions
10

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 04/28/2017
• Question Category: OS