I Need To Calculate Total Hours

[scw1217]

Okay, assume I am a total Excel dumby (which is the truth). I know only
basic functions of Add, Subtract, and Multiply. However, I need to set
up a payroll time sheet. Here's what I need to do. Column A1 is start
time (8:30 AM). Column A2 is end time for lunch (12:00 PM). Column A3
is start time after lunch (2:00 PM) and Column A4 is End Time (5:00
PM). Column A5 needs to be total hours which is this example would be
6.5 hours. I can then make Column A6 the formula for $, which I
already know how to do. My question is this, how to I put in the
formula that will subtract all those hours and give me the 6.5 total.
I have been doing this by hand, but it would be nice to have Excel (97)
do it for me. Be gentle and go slowly.

 

[Chip Pearson]

Try something like

=((A4-A1)-(A3-A2))*24


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Paul]

Okay, assume I am a total Excel dumby (which is the truth). I know only
basic functions of Add, Subtract, and Multiply. However, I need to set
up a payroll time sheet. Here's what I need to do. Column A1 is start
time (8:30 AM). Column A2 is end time for lunch (12:00 PM). Column A3
is start time after lunch (2:00 PM) and Column A4 is End Time (5:00
PM). Column A5 needs to be total hours which is this example would be
6.5 hours. I can then make Column A6 the formula for $, which I
already know how to do. My question is this, how to I put in the
formula that will subtract all those hours and give me the 6.5 total.
I have been doing this by hand, but it would be nice to have Excel (97)
do it for me. Be gentle and go slowly.

Using your references A1, A2 and so on (although I have no idea what "Column
A2" means!), the number of hours is
=((A2-A1)+(A4-A3))*24

A2-A1 calculates the morning time difference
A4-A3 calculates the afternoon time difference
Add together and multiply the total by 24 to get the total number of hours.
(You need to multiply by 24 because times are stored as fractions of a day.)

 

[scw1217]

Thanks! That worked great! I changed from rows to columns so the
formula ended up as =((C1-B1)+(E1-D1))*24