Home 
Search 
Today's Posts 
#1




how to calculate hours worked daily & minus 30 min lunch, 7am5pm
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. 
#2




how to calculate hours worked daily & minus 30 min lunch, 7am5pm
Debby_Jo 
Excel deals with dates and times like this: DDDDD.TTTT  the integer part of the number is the number of days after 1/1/1900, and the decimal part is the time portion  essentially the percentage of the day elapsed. So 0.5 means that 1/2 of the day has elapsed, or its 12:00:00pm. One hour is 1/24th of the day, or 0.041667, and 30 minutes is half that  0.020833. So: A B C 1 8:00am 5:00pm =(B1A10.020833)*24 Remember you have to multiply by 24 to convert the % of the day into the actual number of hours. Also, since Excel assumes that, if you're working with times, you want an answer in times, you'll need to format C1 to just regular numbers. Then you can add all the C:C calculations to weekly, biweekly, or monthly totals. HTH "Debby_Jo" wrote: 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. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
How can I calculate daily hours worked minus lunch to eual a decim  Excel Worksheet Functions  
Drivers Hours Timesheet  Calculate Hours Worked on Weekly Basis  Excel Discussion (Misc queries)  
Calculate hours worked  New Users to Excel  
Need formula to calculate hours worked  Excel Discussion (Misc queries)  
CALCULATE HOURS WORKED  Excel Discussion (Misc queries) 