time sheets

S

Sam

I'm new to excel. I'm setting up a time sheet and would like to know what
calulation I use to figure out the hours worked with a 1/2 hour not being
paid for.
Thanks in advance.
 
P

Paul B

Sam, if you are talking about =(F4-C4+(F4<C4))*24

if you put your mouse on the lower right hand corner of the cell it will
turn into a small + drag down and it will fill the next row with
=(F5-C5+(F5<C5))*24
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Top