Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 * |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 - |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula question on time in seconds | Excel Discussion (Misc queries) | |||
Question for about using IF formula LEFT function at the same time | Excel Worksheet Functions | |||
Question calculation time and Index formula | Excel Worksheet Functions | |||
Formula TIME question | Excel Discussion (Misc queries) | |||
time formula question... | Excel Discussion (Misc queries) |