How can I calculate daily hours worked minus lunch to eual a d
"Pete_UK" wrote:
Assuming your times are in A1 to D1, then try this:
=(D1-C1+B1-A1)*24
Format the cell as number with 2 dp.
Hope this helps.
Pete
On Mar 28, 12:00 am, lili wrote:
example IN 2:45AM, Lunch Out 12:00PM, Lunch In 1:00PM, Out 5:00PM
=13.25
|