Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Please help,
I need a VB code for assumed lunch. =(E6<D6)+E6-D6+(G6<F6)+G6-F6 is the code I am currently using to calculate total hours worked per day. D6 is "StartWork", E6 is "StartLunch", F6 is "EndLunch" G6 is "EndWork". Our employees do not punch out for lunch unless if they are going to be longer than 1/2 hour. Otherwise we just assume 1/2 hour or "no lunch" if they write "no lunch" on their card. To address the assumed lunch: What I need is a VB code so that what I enter in "StartWork" (E6) is automaticaly repeated in "StartLunch" (F6) and puts the time that is 1/2 hour later in "EndLunch". I already have a macro to address the no lunch issue. Thank you, Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can Excel do daily timesheet, -lunch time, & not use colon in. | Excel Worksheet Functions |