I want to create a formula

  1. malinda18751
    malinda18751
    I want to make attendance sheet to calculate working hrs. But i couldn't deduct lunch or dinner hrs of it.

    Ex : work start at 7.00 am and off at 5.00 pm, lunch time is 12.30pm to 1.15 pm is want to deduct.
    If work start at 12.30pm and off at 5.00 pm, lunch time is not deduct.
    If work start at 6.00pm and off at 6.00 am, dinner time 8.30pm - 9.30 pm is want to deduct.
    If work start at 7.00am and off at next day 6.00am lunch and dinner must deduct.
    And I want to calculate late presenters work hrs. Example : If some one work start at 8.30 am and off at 5.00pm

    Plz help me to make a attendance sheet in excel. I tried about one month in different ways but I couldn't.
Results 1 to 1 of 1

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1