S
saltnsnails
I am reposting this discussion on a question I have been working on for
several days below. It seems to be quite a challenge. Just seeing if anyone
else had input. I know it is generally frowned upon to report the same
information, I am just desperate to get this resolved. Any help is
appreciated!
-CRM
Valko,
Here is the original formula below in cell C43. The only issue is that
originally the time ins and time outs started in column E. We had to add one
more T.I./T.O. set so they got put in columns C & D. I inherited this
worksheet so I am having difficulty editing it. I thought perhaps if you had
the original formula before the added time columns, it might help you or
someone else find a resolution quicker.
Thanks!
-CRM
=IF($F$10>($A43),IF($E$10>$B43,0,IF($A43>=$E$10,IF($F$10<$B43,($F$10-$B43)*1440/60,0.25),IF($F$10>$A43,($B43-$E$10)*1440/60))),0)+IF($H$10>($A43),IF($G$10>$B43,0,IF($A43>=$G$10,IF($H$10<$B43,($H$10-$A43)*1440/60,0.25),IF($H$10>$B43,($B43-$G$10)*1440/60))),0)+IF($J$10>($A43),IF($I$10>$B43,0,IF($A43>=$I$10,IF($J$10<$B43,($J$10-$A43)*1440/60,0.25),IF($J$10>$B43,($B43-$I$10)*1440/60))),0)
several days below. It seems to be quite a challenge. Just seeing if anyone
else had input. I know it is generally frowned upon to report the same
information, I am just desperate to get this resolved. Any help is
appreciated!
-CRM
Valko,
Here is the original formula below in cell C43. The only issue is that
originally the time ins and time outs started in column E. We had to add one
more T.I./T.O. set so they got put in columns C & D. I inherited this
worksheet so I am having difficulty editing it. I thought perhaps if you had
the original formula before the added time columns, it might help you or
someone else find a resolution quicker.
Thanks!
-CRM
=IF($F$10>($A43),IF($E$10>$B43,0,IF($A43>=$E$10,IF($F$10<$B43,($F$10-$B43)*1440/60,0.25),IF($F$10>$A43,($B43-$E$10)*1440/60))),0)+IF($H$10>($A43),IF($G$10>$B43,0,IF($A43>=$G$10,IF($H$10<$B43,($H$10-$A43)*1440/60,0.25),IF($H$10>$B43,($B43-$G$10)*1440/60))),0)+IF($J$10>($A43),IF($I$10>$B43,0,IF($A43>=$I$10,IF($J$10<$B43,($J$10-$A43)*1440/60,0.25),IF($J$10>$B43,($B43-$I$10)*1440/60))),0)