Excel Formula - tds calculation Xls Download.. CiteHR
Home > Human Resource Section > Talk To Seniors

Zainab Ali Started The Discussion:

I want to put a formula in excel attendance sheet to calculate late time of employees if they r late than official time, for example

my office time start at 8:00Am I want to calculate the late timings of employees if they r reaching 10 minutes late or 1 hour then in 1 column.
it would come automatically.

plz help to put formula for this..

Many thanks

dcp149 -  Member Since: Jan 2007
In excel sheet, make four columns as under:

a) 1st column : Date : 1st Jun, 2nd Jun .....
b) 2nd column : starting time, say 8:00 (write in this format only)
c) 3rd column : Entry time of employees, say 10:10 (write in this format only)
d) 4th column : Late by ___ minutes (comes automatically by applying the formula : (c3-b3) * 1440

If you want any more clarification, do get back to me on



sanjuktaganguly -  Member Since: Sep 2008
Can anybody can tell me that what kind of excel knowledge is required in HR generalist profile..:icon9:

sanjuktaganguly -  Member Since: Sep 2008
Please help me out asap,because all the time the requirement is for EXCEL KNOWLEDGE...:sad:

dhamal shri -  Member Since: Jul 2009
i want change colour when comming charactor "A" in red so pls help and send excel formula in my email.id shrikantdhamal0@gmail.com

Attached FilesProvided by community member dhamal shri. Join us to learn and grow with your peers.
File Type: xls RajisterOctomber_09(1).xls (1.89 MB, 1211 views)
Joshuaalvina -  Member Since: Aug 2009
Simple first go to conditional formatting in the menu then select highlight cells then u select text that contains and type A the click ok. Regards, JA


  • Do not post anything derogatory about any company or person.
  • Sharing articles from other websites should be done by posting a link to the original article.
  • To discuss sensitive issues create a pseudo/anonymous account.
  • Please avoid repeat posting your company profile - such accounts are removed automatically.
  • Found This Useful? +Vote Up This Via Google.  

    Why Vote? User validation is extremely important for good content to prosper.
    Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

    3M Users, 100K+ Documents & 450K+ Discussions

    Share »

    Cite.Co helps people come together to solve each other's problems on all aspects of professional life.
    Community Support & Professional Insights. Login or Register.

    About Us - Advertise - Contact Us - RSS   On Google+  
    All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
    Privacy Policy | Disclaimer | Terms Of Service
    Facebook Page | Follow Us On Twitter | Linkedin Network