Question about a formula for time ..
 

I have a spreadsheet that calculates my in & out time at work .. I have that
set up with a date, time in, time out .. my formula correctly adds my number
of hours .. I take a standard hour for lunch .. so I've made another column
... and I want it to subtract one hour from that total to give me net hours
worked .. I can't seem to get my formulas to work for the final two columns
... here is my questions ..

On the column that has the 1 hour for lunch .. what would I format that as?

For example here is my spreadsheet .. I can't figure out the formula for
lunch break colun & net hours worked column ..

I appreciate any & all help for the Excel gurus & experts on here :) ..
A B C D E
F
Date TIME IN TIME OUT TOTAL HRS WK. LUNCH BREAK NET HRS WORKED
09/08/08 8:00 AM 5:45 PM 9:45 1.00

Question about a formula for time ..
 

In F2 try this formula:

=D2-E2/24

and format the cell as time.

Alternatively, enter a proper time in E2 (i.e. 1:00:00) and then you
can just do:

=D2-E2

As you have it, you are entering decimal hours in E2, so if you only
took 45 minutes for lunch one day then you will have to enter this as
0.75

Hope this helps.

Pete

On Sep 21, 1:15*am, hrbsh97 wrote:
I have a spreadsheet that calculates my in & out time at work .. I have that
set up with a date, time in, time out .. my formula correctly adds my number
of hours .. I take a standard hour for lunch .. so I've made another column
.. and I want it to subtract one hour from that total to give me net hours
worked .. I can't seem to get my formulas to work for the final two columns
.. here is my questions ..

On the column that has the 1 hour for lunch .. what would I format that as?

For example here is my spreadsheet .. I can't figure out the formula for
lunch break colun & net hours worked column ..

I appreciate any & all help for the Excel gurus & experts on here :) ..
A * * * * * * *B * * * * * * * C * * * * * * D * * * * * * * * * * * *E * * *
* * * * * * *F
Date * *TIME IN TIME OUT * * * *TOTAL HRS WK. *LUNCH BREAK NET HRS WORKED
09/08/08 * * * *8:00 AM 5:45 PM 9:45 * * * * * * 1.00 *

Thanks Pete!
 

Pete .. thanks for the response to my post .. that worked like a charm!! .. I
had formatted the one cell incorrectly ..

Many thanks for the reply!!

:)

"Pete_UK" wrote:

In F2 try this formula:

=D2-E2/24

and format the cell as time.

Alternatively, enter a proper time in E2 (i.e. 1:00:00) and then you
can just do:

=D2-E2

As you have it, you are entering decimal hours in E2, so if you only
took 45 minutes for lunch one day then you will have to enter this as
0.75

Hope this helps.

Pete

On Sep 21, 1:15 am, hrbsh97 wrote:
I have a spreadsheet that calculates my in & out time at work .. I have that
set up with a date, time in, time out .. my formula correctly adds my number
of hours .. I take a standard hour for lunch .. so I've made another column
.. and I want it to subtract one hour from that total to give me net hours
worked .. I can't seem to get my formulas to work for the final two columns
.. here is my questions ..

On the column that has the 1 hour for lunch .. what would I format that as?

For example here is my spreadsheet .. I can't figure out the formula for
lunch break colun & net hours worked column ..

I appreciate any & all help for the Excel gurus & experts on here :) ..
A B C D E
F
Date TIME IN TIME OUT TOTAL HRS WK. LUNCH BREAK NET HRS WORKED
09/08/08 8:00 AM 5:45 PM 9:45 1.00

Thanks Pete!
 

You're welcome - thanks for feeding back.

Pete

On Sep 21, 2:23*am, hrbsh97 wrote:
Pete .. thanks for the response to my post .. that worked like a charm!! ... I
had formatted the one cell incorrectly ..

Many thanks for the reply!!

:)



"Pete_UK" wrote:
In F2 try this formula:

=D2-E2/24

and format the cell as time.

Alternatively, enter a proper time in E2 (i.e. 1:00:00) and then you
can just do:

=D2-E2

As you have it, you are entering decimal hours in E2, so if you only
took 45 minutes for lunch one day then you will have to enter this as
0.75

Hope this helps.

Pete

On Sep 21, 1:15 am, hrbsh97 wrote:
I have a spreadsheet that calculates my in & out time at work .. I have that
set up with a date, time in, time out .. my formula correctly adds my number
of hours .. I take a standard hour for lunch .. so I've made another column
.. and I want it to subtract one hour from that total to give me net hours
worked .. I can't seem to get my formulas to work for the final two columns
.. here is my questions ..

On the column that has the 1 hour for lunch .. what would I format that as?

For example here is my spreadsheet .. I can't figure out the formula for
lunch break colun & net hours worked column ..

I appreciate any & all help for the Excel gurus & experts on here :) ...
A * * * * * * *B * * * * * * * C * * * * * * D * * * * * * * * * * * *E * * *
* * * * * * *F
Date * *TIME IN TIME OUT * * * *TOTAL HRS WK. *LUNCH BREAK NET HRS WORKED
09/08/08 * * * *8:00 AM 5:45 PM 9:45 * * * * * * 1.00 *- Hide quoted text -

- Show quoted text -