Biweekly timesheet formula error

[Chris Syx]

Hello all,

I am creating a biweekly timesheet and I have an error in my formula somewhere. The spreadsheet formatting starting in column c is time in, lunch out, lunch in, time out. My current formula is:=((F11-C11+(F11<C11))-(E11-D11+(E11<D11)))*24. The problem I am facing is if I enter a time in the formula calculates in error. An example is if I enter 7:00 am in C11 I get a result of 17. I would like this to show a total of zero until an entry for lunch out, or time out.

Thanks for the help!

 

[GS]

Chris Syx explained on 4/18/2012 :

Hello all,

I am creating a biweekly timesheet and I have an error in my formula
somewhere. The spreadsheet formatting starting in column c is time in, lunch
out, lunch in, time out. My current formula
is:=((F11-C11+(F11<C11))-(E11-D11+(E11<D11)))*24. The problem I am facing is
if I enter a time in the formula calculates in error. An example is if I
enter 7:00 am in C11 I get a result of 17. I would like this to show a total
of zero until an entry for lunch out, or time out.

Thanks for the help!

Here's the formula I use for a single stop/start. You could easily
modify it to include more stop/start values...

=IF(AND(Start<>"",Stop<>""),ROUND(MOD(Stop-Start,1)*24,2),"")

...where 'Start' and 'Stop' are column-absolute, row-relative defined
names (local scope).

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Chris Syx]

Garry,

Thanks! This is working perfect.

 

[GS]

Chris Syx formulated the question :

Garry,

Thanks! This is working perfect.

You're welcome! Glad to be of help. Thanks for the feedback!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion