calculating time

Important Notice

Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Respected,
    Can I have the solution like
    when an employee enters his/her employee ID 1st time,
    HARD coded date and time is entered in 2nd cell ,
    2nd time , HARD coded time is entered in break start ,
    3rd time then HARD coded time is entered in break end and
    4th time HARD coded date and time is entered in day end
    ----------ColumnA ColumnB ColumnC ColumnD ColumnE ColumnF
    ROW1 Emp ID DAYstart Breakstart BreakEnd DayEnd calculate HH:MM depending on hours done

    Zohar Batterywala

  • Respected Chirayuw,
    concept is that the front end is only given space to enter employee ID.
    An employee is not given access to excel sheet to enter date and time manually.
    (problem is that some emp[loyees are too dumb to make mistake in entering
    while others are too smart to edit it so that complete 8 hours are counted though they have worked less)
    Zohar Batterywala

  • Respected Chirayuw,
    Or like we can hide column B to F, only allowing employee ID------- to enter in column A
    Zoharf Batterywala

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!