Home |
Search |
Today's Posts |
#1
|
|||
|
|||
subtracting a break from hours worked
windows xp, excel 2003. i have never used any type of spreasheet before so am
needing help. i have downloaded cpearson's timesheet which was a great help for setting up my timesheet. 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 sheet 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 |
#2
|
|||
|
|||
One way:
=(I2-H2+(I2<H2))*24 - 0.5 In article , "truecam" wrote: windows xp, excel 2003. i have never used any type of spreasheet before so am needing help. i have downloaded cpearson's timesheet which was a great help for setting up my timesheet. 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 sheet 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 |
#3
|
|||
|
|||
"JE McGimpsey" wrote: One way: =(I2-H2+(I2<H2))*24 - 0.5 In article , "truecam" wrote: windows xp, excel 2003. i have never used any type of spreasheet before so am needing help. i have downloaded cpearson's timesheet which was a great help for setting up my timesheet. 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 sheet 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 thank you so much it worked perfectly often the answer is extremely simple isn't it. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel needs hh:mm where hh>24 for hours worked per week | Excel Worksheet Functions | |||
how do i calculate hours worked in excel? | Excel Worksheet Functions | |||
How can I make an Employment Schedule that Tabulates hours worked. | Excel Worksheet Functions | |||
Subtracting paid hours from unpaid hours | Excel Worksheet Functions | |||
calculate average hours worked | Excel Worksheet Functions |