HR Zone » Human Resource Management » How to caluclate Work hours

1842 Views
  6 Replies

0
Vote Vote
How to caluclate Work hours
Satya
Satya Picture
21 Posts
back to top
Posted 29-01-2009Reply

Hello Friends,



I needed your valuable suggestion on Work hour calculations.



My office working hours is from 9:30 AM to 6:30 PM with a lunch break of 30 Mins. Ours is a 5 day week. I am supposed to send the individuals average weekly workings hours by every week ending. Here my doubt is how to calculate the Lunch break. Inclusive of lunch break work timings are coming up to 45 hours for a week. Exclusive of Lunch hour is coming up to 42hours 30 minutes. Not all my staff members are going out for lunch.



If at all I am calculating weekly working hours as 45 hours. Employees who are not going out for lunch are short with 2hours 30 minutes for week.If calculating the weekly working hours @ 42 hours 30 minutes employees taking luch in office are benefited with 2 hours 30 minutes.



So, seniors I needed your valuable suggestion in this regard.



Thanks

--

SATYA PRAKASH

+91-9966907010

Rajila
Rajila Picture
201 Posts
back to top
  Rated 0 | Posted 29-01-2009

Hi Sathya,

Check whether u can use this table for ur calculation

Rajila

Attached Files
Attendance calculation.xls (9.1 KB, 19 views)
Cute Boy
Cute Boy Picture
20 Posts
back to top
  Rated 0 | Posted 02-02-2009

Hey rajila,
V can not open that file..................

Cute Boy
Cute Boy Picture
20 Posts
back to top
  Rated 0 | Posted 03-02-2009

Hi Rajila,

U may updated but still same problem.........................

Swapna
Swapna Picture
34 Posts
back to top
  Rated 0 | Posted 03-02-2009

Hey rajila,

V can not open that file..................


Hi Rajila

Still facing the same problem not able to open the document you have sent.


Regards
swapna

Chemmalar
Chemmalar Picture
1 Posts
back to top
  Rated 0 | Posted 03-02-2009

Hey rajila,

V can not open that file..................


Hi Rajila



Still facing the same problem not able to open the document you have sent.<... See Swapna's complete reply


Swapna,

Even i couldnt open the excel sheet.

Satya
Satya Picture
21 Posts
back to top
  Rated 0 | Posted 04-02-2009

I hope dat attachment is not working.Could u can resend it.

0
Vote Vote
Lessnote

Recently in HR Forums

Hitesh posted a new forum topic in
06-04-2023
Arun posted a new forum topic in
15-02-2023
 
Recent (10) | HR | Both
HR | Both   1 of 10
23-09-2019
27-01-2018
27-01-2018
07-08-2017
26-05-2017
Arun
Arun
Read this topic:
Joke ####@@@####
26-05-2017
25-05-2017
03-04-2017
27-03-2017
27-03-2017