Parwiz
6

Hi Dear Friends,
I come back to you all Dears to get drop knowledge of yours by solving a problem, using FORMULA.
Mostly in Afghanistan working hours is: 8:00AM to 4:00PM = 8 hours.
If an employ is working part time, for example 9 - 4 or 10 - 4 or 1 - 4. 7, 6, or 4 hours a day.
I am going to test it in an excel sheet using formula to enter in - out hours, automatically show the total working hours as I attached the template.
It is highly appreciated if you could help me!
Many thanks in advance!

From Italy
Attached Files (Download Requires Membership)
File Type: zip Working Hours.zip (8.3 KB, 2695 views)

Parwiz
6

Dears, I need this help urgently, anyone can help me?! Regards,
From Italy
dmuralidhar
9

Hi Parwiz,
You can simply find out the difference in both times by subtracting the in-time from out-time (=D2-C2). And change the result cell's (E2) format to 'h:mm'.
You can refer the modification I'd made in your template (I'd changed one employee's out time for more clarity).
Have a nice day!
Muralidhar

From India, Chennai
Attached Files (Download Requires Membership)
File Type: xls Working Hours Revised.xls (23.0 KB, 3159 views)

yogitajoshi2013@yahoo.com
I would like to know that how many working hours have to complete in a day in the corporate office which located in Manesar.?
From India, Delhi
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.