View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Debby_Jo Debby_Jo is offline
external usenet poster
 
Posts: 5
Default how to calculate hours worked daily & minus 30 min lunch, 7am-5pm

I need a formula in layman's terms how to calculate total hours worked daily
with the subtraction of 30 minutes for lunchtime. And then calculate the
weekly subtotals for a weekly grand total.