I need help with an excel formula please.?

Question

I need to add and subtract several items in the same row for example:

Row 1 Columns A - B + C - D = E

I'm trying to set up a time clock spreadsheet to keep up with hours.
I'm going to set up Column A as the date and I have selected the other columns to be time. Any help would be appreciated! Thanks.

Answer 1

You probably don't need to include column A in the formula if this is the date as it is not really needed.

I presume you are trying to put a start time, an end time and a break duration. If so, do the following:

Column A = date
Column B = start time
Column C = start of break
Column D = end of break
Coulmn E = end time

format columns B to F as Time with just hours and minutes.

In cell F1 enter the formula:
=((E1-B1)-(D1-C1))

This will give you the number of hours and minutes for the day in F1.

You can then sum column F to give you hours over a week, etc.

Answer 2

Go to your sum sign. Click it with your cursur in the column where you want the total to be. After you clikc the sum sign, you will see SUM () and it will be blinking. Click on A - B + C - D. That will give you the sum in column E.

I hope this helps.

Answer 3

go where it says ask quiestion on the corner ..or just high light it n click on a thing that looks like an E..it's called auto sum..but click on the arrow n then click more funtions n there u will type what function u wanted