The formula refers to 34 in B5 but B5 is 36, not 34
Regards
David Grugeon
On 15 May 2013 16:41, P.VIJAYKUMAR wrote:
> Respected Experts,
>
> My exact requirement is that if 12(or any constant number specific to
> login) is typed in Cell B4 of the attachment it should display the log-in
> time
Respected Experts,
My exact requirement is that if 12(or any constant number specific to
login) is typed in Cell B4 of the attachment it should display the log-in
time according to the formula or otherwise working.In the same way if 34
(or any constant number specific to log-out) is mentioned in
Your query is not clear. There are no log out times in the attachment.
Please elaborate.
On Wed, May 15, 2013 at 10:59 AM, P.VIJAYKUMAR wrote:
> Respected Experts,
>
> I Have an excel sheet which is used for getting the log-in and log-out
> times of employees.I have used if formulas as is seen
hi vijayakumar,
tell me what is your exact requirement, so that we can modify the formula.
On 15 May 2013 10:59, P.VIJAYKUMAR wrote:
> Respected Experts,
>
> I Have an excel sheet which is used for getting the log-in and log-out
> times of employees.I have used if formulas as is seen in the
Respected Experts,
I Have an excel sheet which is used for getting the log-in and log-out
times of employees.I have used if formulas as is seen in the attachment.
But, when log-in time is updated unfortunately log-out time is also
changing even if the IF condition does not apply in the case. I don
