What formula in excel can be used to calculate the total hours a person has worked?

If you put in the time they started and the time they finished, you can subtract the earlier time from the later time. The time must be put in in a time format, with a colon between the hours and minutes of the time. So if they started at 9:30am you'd put it into a cell like this: 09:30 You would put the time they finish in another cell.

Then in another cell you put a formula to subtract the earlier time from the later time. So if you had 09:30 in cell A3 and 15:45 in cell A4, then in cell A5 you could have a formula like this: A4-A3 If they have breaks, you'd have to have several formulas to find the time worked between each start point and end point. All those times could then be added to find out their total time A good way to calculate breaks in Excel using only one formula can be found in the training section of calculatehours.com : Log in- - - - -using an hh:mm format in cell A1 Log out - - - using an hh:mm format in cell B1 Log in- - - - -using an hh:mm format in cell C1 Log out - - - using an hh:mm format in cell D1 Than in cell E1 type: SUM((B1-A1)+(E1-D1)*24 Change the cell format of E1 to "Number" with 2 decimal places If that's too difficult, you can download ready Excel Time sheet Templates from: a href="calculatehours.com/timesheet-template-library.html.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.