Solved Making excel time sheet ie 06.00 star 12.00 finis = 6 hrs

September 24, 2013 at 01:53:15
Specs: Windows XP
HOW DO I SHOW HOURS WORKED ON A SPREAD SHEET WHEN I HAVE A START & FINISH TIME BUT ALSO NEED TO SHOW 45 MINS LUNCH BREAK

See More: Making excel time sheet ie 06.00 star 12.00 finis = 6 hrs

Report •


#1
September 25, 2013 at 08:11:24
✔ Best Answer
Here is one way of doing it.

With your data like:

       A          B         C          D      E       F
1)    Date     Arrive  Lunch Out  Lunch In  Depart  Total
2) 09/25/2013   8:00     13:00      13:45    17:00      

In cell F2 enter the formula: =(E2-B2)-(D2-C2)

See how that works for you.

Also, please Do Not post in all CAPS, it is the equivalent of shouting and many find it rude.

MIKE

http://www.skeptic.com/

message edited by mmcconaghy


Report •
Related Solutions


Ask Question