HR Letter Formats
Free Human Resource Forms, Formats & Questionnaires

Posts tagged "Formula"

Excel Formula Sheet

I am attaching herewith the excel formula sheet. Please go through and let me know your valuable inputs.

 

Function keys in Microsoft Excel
Function Key SHIFT CTRL ALT CTRL+SHIFT ALT+SHIFT
F1 Display Help or the Office Assistant What’s This? Insert a chart sheet Insert a new worksheet
F2 Edit the active cell Edit a cell comment Save As command Save command
F3 Paste a name into a formula Paste a function into a formula Define a name Create names by using row and column labels
F4 Repeat the last action Repeat the last Find (Find Next) Close the window Exit
F5 Go To Display the Find dialog box Restore the window size
F6 Move to the next pane Move to the previous pane Move to the next workbook window Move to the previous workbook window
F7 Spelling command Move the window
F8 Extend a selection Add to the selection Resize the window Display the Macro dialog box
F9 Calculate all sheets in all open workbooks Calculate the active worksheet Minimize the workbook
F10 Make the menu bar active Display a shortcut menu (right click) Maximize or restore the workbook window
F11 Create a chart Insert a new worksheet Insert a Microsoft Excel 4.0 macro sheet Display Visual Basic Editor
F12 Save As command Save command Open command Print command

2 comments - What do you think?
Posted by Hrformats - October 13, 2012 at 2:32 PM

Categories: HR   Tags: , ,

Timesheet Formula In Excel File Format

 I have Attached Timesheet Formula

Employee ID: T Percent
Employee Name:
Employee Designation:
Location: Month / Year: Apr 2012 NATIONAL STAFF PERSONNEL ACTIVITY REPORT O
T
Date 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 A
COST CENTERS: Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon ### L
O 0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
0 0%
Total Hours: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0%
TIME OFF:
Holiday 0
Vacation 0
Sick 0
Unpaid 0
Other 8 8
Total Time Off: 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 8 0 0 0 0 0 8
Sick
  Maximum Hours ACCRUED TIME OFF    Vacation Leave
Accrued Vacation 220 135.2
Permitted Hours Beginning of Month
12 12
200 Hours + hours earned during month
  0 0
– hours taken during month
232 147.2
Hours at End of Month
Employee Signature: Date:
Supervisor Signature: Date:

 

Click Here To Download Timesheet Formula

Be the first to comment - What do you think?
Posted by Hrformats - May 1, 2012 at 11:33 AM

Categories: HR   Tags: ,

Formula For Attendance Format

 I have Attached Formula For Attendance Format

Month Name : Working days: 22
Sno Name 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 FDP HDP %
1 Employee1 P P P P OD P CL P P P CL P P P P P P P P P CL P 19 0 86
2 Employee2 P P P P P P P P P P EL P P P P P EL P P P P P 20 0 91
3 Employee3 CL P P P P P P P P P P OD P P P P P HF P P P P 20 1 93
4 Employee4 P P P P P HF P P P P P P P P P P P P P P P P 21 1 98
5 Employee5 P P P P P P P P P P CL P P P CL P P P P P P P 20 0 91
6 Employee6 P P P P P P P P P P P P P P P P P P P P CL CL 20 0 91
7 Employee7 P P P P CL EL EL EL P P EL P P P P P P P P P P P 17 0 77
8 Employee8 A A A A A A A A A A A A A A A A A A A A A A 0 0 0
9 Employee9 P P P P EL P P P P P P CM P P P P P P P P P A 19 0 86
10 Employee10 P P P P P P P P P P P P P P P P P P P P P P 22 0 100
11 Employee11 P P P P P P P OD P P P P P P P P P RL P P P P 21 0 95
12 Employee12 P P CL P P P P P P P P P P P P HF P RL P P P P 19 1 89
13 Employee13 OD OD OD OD OD OD P P P P P P P P P P P P P P P P 22 0 100
Note:
P- Present
OD- OnDuty
CL- Casual Leave
CM-Compensation Leave
EL-Earned Leave
A-Absent
HF-Half day present
RL-Restricted Leave

 

Click Here To Download Formula For Attendance Format

Be the first to comment - What do you think?
Posted by Hrformats - April 17, 2012 at 10:59 AM

Categories: HR   Tags: , , ,