Hello my faithful saviours. I am here again asking for some assistance. I
have been working on and tweaking our time sheets and the one thing I can’t
seem to do is to find if it is possible to do the calculations without having
to use military time. I want the employees to be able to just put the actual
time instead of the military. Is this possible and how do I do it. I am sure
it is an easy fix but nothing is easy for me. This is the currecnt code for
daily hours worked minus lunch. =IF(C10=0, 8, IF(F10=0, " ",
IF((SUM(((D10-C10)+(F10-E10))*24))<0, SUM(((D10-C10)+(#REF!-E10)+F10)*24+1),
SUM(((D10-C10)+(F10-E10))*24))))

If anyone can assist me, I would greatly appreciate it. Thank you again.

Before you go too much further, you better figure out where the #REF! comes
from and fix it.

"Corkey" wrote:

> Hello my faithful saviours. I am here again asking for some assistance. I
> have been working on and tweaking our time sheets and the one thing I can’t
> seem to do is to find if it is possible to do the calculations without having
> to use military time. I want the employees to be able to just put the actual
> time instead of the military. Is this possible and how do I do it. I am sure
> it is an easy fix but nothing is easy for me. This is the currecnt code for
> daily hours worked minus lunch. =IF(C10=0, 8, IF(F10=0, " ",
> IF((SUM(((D10-C10)+(F10-E10))*24))<0, SUM(((D10-C10)+(#REF!-E10)+F10)*24+1),
> SUM(((D10-C10)+(F10-E10))*24))))
>
> If anyone can assist me, I would greatly appreciate it. Thank you again.
>
>

And don't use a space " " in IF(F10=0, " ",

Use "" instead.


Gord Dibben MS Excel MVP

On Mon, 2 Nov 2009 10:24:01 -0800, Barb Reinhardt
<(E-Mail Removed)> wrote:

>Before you go too much further, you better figure out where the #REF! comes
>from and fix it.
>
>"Corkey" wrote:
>
>> Hello my faithful saviours. I am here again asking for some assistance. I
>> have been working on and tweaking our time sheets and the one thing I can’t
>> seem to do is to find if it is possible to do the calculations without having
>> to use military time. I want the employees to be able to just put the actual
>> time instead of the military. Is this possible and how do I do it. I am sure
>> it is an easy fix but nothing is easy for me. This is the currecnt code for
>> daily hours worked minus lunch. =IF(C10=0, 8, IF(F10=0, " ",
>> IF((SUM(((D10-C10)+(F10-E10))*24))<0, SUM(((D10-C10)+(#REF!-E10)+F10)*24+1),
>> SUM(((D10-C10)+(F10-E10))*24))))
>>
>> If anyone can assist me, I would greatly appreciate it. Thank you again.
>>
>>

Sorry, I did find the Ref error after I copied it. I did fix that and the ""
issue. Thank you for the advice on that.

"Corkey" wrote:

> Hello my faithful saviours. I am here again asking for some assistance. I
> have been working on and tweaking our time sheets and the one thing I can’t
> seem to do is to find if it is possible to do the calculations without having
> to use military time. I want the employees to be able to just put the actual
> time instead of the military. Is this possible and how do I do it. I am sure
> it is an easy fix but nothing is easy for me. This is the currecnt code for
> daily hours worked minus lunch. =IF(C10=0, 8, IF(F10=0, " ",
> IF((SUM(((D10-C10)+(F10-E10))*24))<0, SUM(((D10-C10)+(#REF!-E10)+F10)*24+1),
> SUM(((D10-C10)+(F10-E10))*24))))
>
> If anyone can assist me, I would greatly appreciate it. Thank you again.
>
>

(C8=0, 8, IF(F8=0, "", IF((SUM(((D8-C8)+(F8-E8))*24))<0,
SUM(((D8-C8)+($E$24-E8)+F8)*24+1), SUM(((D8-C8)+(F8-E8))*24))))

"Corkey" wrote:

> Hello my faithful saviours. I am here again asking for some assistance. I
> have been working on and tweaking our time sheets and the one thing I can’t
> seem to do is to find if it is possible to do the calculations without having
> to use military time. I want the employees to be able to just put the actual
> time instead of the military. Is this possible and how do I do it. I am sure
> it is an easy fix but nothing is easy for me. This is the currecnt code for
> daily hours worked minus lunch. =IF(C10=0, 8, IF(F10=0, " ",
> IF((SUM(((D10-C10)+(F10-E10))*24))<0, SUM(((D10-C10)+(#REF!-E10)+F10)*24+1),
> SUM(((D10-C10)+(F10-E10))*24))))
>
> If anyone can assist me, I would greatly appreciate it. Thank you again.
>
>