Time Sheet

[Benoit]

Hello,

I wanna create a document in Excel that will allow me to
calculate automatically:

1- How many hours I worked during the day (minus the time
spent on lunch)
2- If over 8 hours, I wanna have a seperate cell that
will tell me how many extra hours I worked (minus the
time spent on lunch)

So, what I'm trying to do is this:

Colum "A": The date
Colum "B": The time I started my day
Colum "c": The time I ended my day
Colum "D": The time I spent on lunch
Colum "E": Total amount of hours worked during the day

Up to here, I'm able to do that on my own. This is where
I'm having problems:

Colum "F": The amount of hours worked beyond 8 hours

I want to, in colum "F", have a formula that will
automatically verify if the number of worked hours is
higher that 8 hours and if so, to let me know how many
hours I've worked...

Thanks!!!

 

[Frank Kabel]

Hi
try the following in F1
=MAX(E1-8/24,0)

if E is a Excel time like 08:30

 

[Andy B]

Hi

Try
=IF(E2>1/3,E2-1/3,"")
in F2 and format it as a time

 

[Don Guillett]

often asked. Using Ron DeBruin's google search add in
http://www.rondebruin.nl/

http://tinyurl.com/3xje5