subtracting a break from hours worked
- From: "truecam" <truecam@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 18 Aug 2005 16:26:04 -0700
windows xp, excel 2003. i have never used any type of sprea*** before so am
needing help.
i have downloaded cpearson's time*** which was a great help for setting up
my time***. it works great but i'm having a problem deducting 0.5hr break,
this break does not have a start or finish time. i dont know where in the
formula to put the break.
the *** is set up like this:
start time finish time break total hours worked
13:00 22:00 0.5 8.5
the formula i am using is =(I2-H2+(I2<H2))*24
where do i put the break part of the formula.
any help would be most appriecated thanks
.
- Follow-Ups:
- Re: subtracting a break from hours worked
- From: JE McGimpsey
- Re: subtracting a break from hours worked
- Prev by Date: Re: formula bar
- Next by Date: Re: How to get an excel doc not saved as "Read Only"
- Previous by thread: Query a database on a server not working
- Next by thread: Re: subtracting a break from hours worked
- Index(es):