Manual Time Clock For My Employees To Punch In And Out

Sep 6, 2005

I currently use a manual time clock for my employees to punch in and out. I then use Excel to tally their times. This is very tedious and error prone.

Is it possible to use Excel as the timeclock itself? I know that the employee can enter the time in a spreadsheet manually. But this also opens the door for error and potential dishonesty.

What I am looking for is, if the employee can punch in and out by doing a keystroke and Excel uses the computer's clock to timestamp.

ADVERTISEMENT

Clock In Multiple Punch In / Punch Out Times Formula

Jan 24, 2014

.I have a data dump of when people have entered in times for when they worked. I need to be able to calculate their total time they worked but running into a problem with people that work over night and those that enter in times that overlap.

An example:

John A. Time in: 12:00 AM Time out: 7:00 AM
John A. Time in: 4:00 AM Time out: 7:00 AM
John A Time in: 7:00PM Time out: 11:59 PM

The total time should be 12 hours but the formula using max/min is giving 23:59 hours/minutes. How would I create a formula so it will calculate the right time? Second, how do I get the formula to not duplicate overlap time? I am getting with the first two rows a total of 10 hours instead of 7 hours because it double counts.

I am a complete novice to formulas

View 1 Replies View Related

Select A Time From A Clock?

Jun 12, 2013

I've linked some cells to the date picker function so a date can be selected from a pop-up calendar.

Is it possible to do the same with a clock function?

View 2 Replies View Related

Use Excel As Time Clock?

Sep 6, 2005

I currently use a manual time clock for my employees to punch in and out. I then use Excel to tally their times. This is very tedious and error prone.

Is it possible to use Excel as the timeclock itself? I know that the employee can enter the time in a spreadsheet manually. But this also opens the door for error and potential dishonesty.

What I am looking for is, if the employee can punch in and out by doing a keystroke and Excel uses the computer's clock to timestamp.

View 9 Replies View Related

Time (clock) Times A Number

Apr 2, 2009

I have a start time in one column, end time in another and a column with the difference between the two. In another column I have profit. In the last column I have profit per hour where I divide the profit by the hours, but since one is hours and the other is a number it gives me an error.

View 4 Replies View Related

Time Related To 24hr Clock

Jun 22, 2009

What i try to achieve is: from 00:00hrs to 24:00hrs = 24hrs which is 1.0 day
Have made the attached spredsheet to calculate it correctly to 1 day. But if you look on the attachment the "total hrs" is saying 00:00 (it transfers to 00:00 when i am putting in 24:00). Basically how am I able to make Excel to display 24:00 insted of 00:00. Maybe there is an add ins availible like the pop up calendar but for times instead.

View 4 Replies View Related

Time Clock And Converting To 3 Min Increment

Jul 8, 2009

Okay I have a basic Time clock calculation in excel (i.e.-(timeout1-timein1)+(timeout2-timein2)="Total time"). What I need to do is convert the "Total time" to be changed to 3 min increments. I don't know if that is the best way to put it but let me show you the chart for the conversions.
3 mins=.05 hrs, 6 mins=.10, etc etc etc.

So lets put this into us

A1 (timein1)= 6:42 AM
A2(timeout1)=11:30 AM
A3(timein2)= 12:00 PM
A4(timeout2)= 5:00 PM (17:00)

So A5(Total Time)=9h 48min, but I need it to equal 9.80 hrs because with the conversion, 48 mins is .80 of an hour. So how can I set up A5 (Total time) to automatically do this calculation? This website is how I would like it to work http://www.1728.com/timecard.htm

View 8 Replies View Related

Calculating Time (24 Hour Clock)

Jul 16, 2012

I've calculated the time of hours worked by staff using th 24 hour clock - "hh:mm" format.

When summing up the hours, it goes a bit haywire, i.e.

Staff A = 12:30
Staff B = 14:00
Sum = 02:30

Total should equal 26:30 (26 and a half hours), however I get returned 02:30. I assume it is down to the 24 hour clock and I so I tried adding 24 to it in the formula bar to get the right answer and it didn't work.

View 5 Replies View Related

Time Countdown - A Live Clock In The Spreadsheet?

Nov 5, 2011

I need to calculate how much time I've got left before the earliest order needs to be despatched (it might be 2 or more on every day). This wouldn't be a problem if orders would be placed daily. But for every item it varies. For example: for "X" product there is an order in 3 days time to be despatched at 19:00. I have built a live clock in the spreadsheet but I can't work out the formula.

P.S. Also I need two time formats, first - days(text) hh:mm second - just a numeric value that can be formated as [hh:mm].

View 5 Replies View Related

Running Clock In Excel With Different Time Zone

Nov 28, 2013

Need running clock in Excel... in A1 I have put running clock which is taking current system time. However, I want to add running clocks for EST in B1 - CST in C1 and PST in D1.

VB code I used to display current system running clock

Global clockOn As Boolean
Sub runClock()
Range("A1").Value = Now()
If clockOn = True Then

[Code] ......

Attached File : Time.xlsm‎

View 3 Replies View Related

How To Make Clock To Show Time In Words

Aug 29, 2013

I want to make a Word Clock. Instead of showing the time as "12:30" I want it to show the words "It is half past twelve"

To Do this I've created a Square of Letters on an excel sheet (one letter per cell!) with black letters and black back grounds, when it is 12.30 I want the relevant letters to (cells) to change the text coulor to white so it shows up.

The cell I'm using are from D8 to P19 and the time is shown in A1

So lets say at 12.30 Cells D9, F12, H14 and M16 need to change from Black Text Colour to White Coulour,

I need a code or some VB that says "If A1 = 12.30 the Cells D9,F12,H14,M16 = White Text Colour, if not Black Text Colour".

View 1 Replies View Related

Time Clock Six Minute Rounding Formula

Apr 27, 2007

I am trying to figure out the written formula for needing this answer:

For a time clock with 6 minute rounding.

If I type in 8:20 as the arrival time, I need it to round to 8:18, so that the final time will be in tenths.

Here is the rounding:

Actual Rounded Minutes in Time Clock
:57, :58, :59, :00, :01, :02
:03, :04, :05, :06, :07, :08
:09, :10, :11, :12, :13, :14
:15, :16, :17, :18, :19, :20
:21, :22, :23, :24, :25, :26
:27, :28, :29, :30, :31, :32
:33, :34, :35, :36, :37, :38
:39, :40, :41, :42, :43, :44
:45, :46, :47, :48, :49, :50
:51, :52, :53, :54, :55, :56

Anything in the same line will round to the bolded time.

Example: I arrive to work at 8:09 and go to lunch at 11:59, it will round to 8:12 and 12:00, making my time worked 3:48 or 3.80. Then I get back from lunch at 12:59 and leave at 17:14, which will round to 13:00 and 17:12, making my time worked 4:12 or 4.2 for the 2nd 1/2 of the day and 8:00 or 8.0 hours for the day.

Time In----------Time Out----------Total Time----------Decimal Time----------Total Hours
...8:12.................12:00..................3:48......................3.80
..13:00................17:12..................4:12......................4.20..........................8.00

The problem is I want to write the actual time and not have to round everything myself and yet I need the decimal time to match what my time clock actually calculates from.

My current formula for the decimal shown above as 3.80 is this: =(HOUR(F7)*60+MINUTE(F7))/60
My current formula for the total time for the day (regular hours) is this: =IF((((E7-D7)+(I7-H7))*24)>8,8,((E7-D7)+(I7-H7))*24)
My current formula for overtime is this: =IF(((E7-D7)+(I7-H7))*24>8,((E7-D7)+(I7-H7))*24-8,0)

This is not a time clock, it is my personal copy of what my time for the week was/is, so that I can compare it to the actual time card that I have to sign off on.

View 9 Replies View Related

Employees Time Sheet

Apr 17, 2009

I am creating a employee time sheet.

I am doing calculation.

I used total hours formula is =(I5-B5+(I5<B5))*24
and also worked hours formula is =((I5-B5-(I5<B5))-(D5-C5+(D5<C5))-(F5-E5+(F5<E5))-(H5-G5+(H5<G5)))*24

Problem is don't show the correct time of total hrs & worked hrs

Here i am attaching my timesheet format.

View 14 Replies View Related

Count Of Employees At Any Given Time

Jan 11, 2013

I am trying to get a count of supervisors and employees at any given time during a few day span. I think maybe a pivot chart might work but I'm stuck.

In my example I have a number of supervisors and employees in separate groups. I would like to type in two dates and two times for an in between time and get the total amount of employees working during a certain time.

Count of Employees at any given time.xlsx

View 6 Replies View Related

Count Of Employees That Worked Within Time-frame

Mar 4, 2008

I am trying to do a timesheet spreadsheets that lists employees clockin and clockout times

Name Start End num hours worked
Cory 02:00 04:00 2
Jack 23:00 05:00 6
Fred 10:00 17:00 7

and then go through the list and and count the number of employees in a certain range.

time range number of employees working
05:00-06:00 1
06:00-07:00 2
07:00-08:00 6
08:00-09:00 5
09:00-10:00
10:00-11:00
11:00-12:00
12:00-13:00..............

View 4 Replies View Related

Countif Formula: Count Of Employees Next To The Each Manager's Name Who Login Time Is Less Then 8 Hours

Oct 6, 2009

I have a sheet in which in Coloum A I have manager names, then in Colum B I have list of Employees reporting to that manager, then in Column C, I have total login time of each employee which should be => 8 hours. In a new sheet, I want to get the count of employees next to the each manager's name who login time is less then 8 hours.

View 3 Replies View Related

Find Next Working Day For Part Time Employees - Exclude Holidays / Weekends

May 16, 2014

My aim is to find the end working date for each task, as well as the next working date for the next task. The working days for this employee are only Monday (6hours), Wednesday (6 hours) and Friday (8hours).
 
D
E
F
G
H
 
Start Date
Duration
Completed Days
Remaining Days
End Date

4
5/05/14
3

=IF(TODAY()>=H4, E4,IF(TODAY()

View 3 Replies View Related

Creating Macro To Copy Time Sheets Data Of Employees Into Master Sheet

Apr 15, 2013

I need to create a macro to copy the data from time sheets of different employees into the Master sheet. ie., each employee's time sheet details in to a separate sheet. If any employee fails to provide his/her time sheet details. a mail must be sent to the respective employees regarding the Time sheet submission. I am providing the sample data of my files too.

Intentionally TS_Employee5.xlsx timesheet isn't provided. In which case, I have to send a mail to the respective employee, in order to remind him about the time sheet.

View 12 Replies View Related

Time (clock) Times A Number= Very High Number?

Apr 2, 2009

I have time start and time end and the difference between the two times. In a third column I have profit and want to calculate the profit per hour. When I divide the profit with the time spent I get a very very high number. If I for instance type in 1 hour of work and profit 100, then I get profit per hour 2400. (profit/hours spent)

On a side note I am trying to get the numbers as 24 hours and not use am or pm and in the spread sheet I get these numbers but in the box at the top where you see the formulas etc. it shows as am and pm. I have uploaded an example.

View 2 Replies View Related

Countdown Clock

Dec 31, 2007

How to add a countdown timer with start, stop, reset functions to an existing Excel spreadsheet?

View 14 Replies View Related

Stop The Clock

Nov 30, 2006

Option Explicit
Private Sub UserForm_Initialize()
lblCloseProgress1.BackColor = &H8000000F
lblCloseProgress2.BackColor = &H8000000F
lblCloseProgress3.BackColor = &H8000000F
lblCloseProgress4.BackColor = &H8000000F
lblCloseProgress5.BackColor = &H8000000F
End Sub......................................

Each of the timdown procedures adds another segment to the countdown clock (if you don't click "Exit" before the five seconds are up, the file closes without saving. All well and good.

Now, if you DO click the "Exit" button, you get a message that the close has been aborted and, upon clearing that messagebox, the file closes anyway!

I think it's something to do with killing all remaining OnTime instructions but I don't know how to go about stopping the clock.

View 3 Replies View Related

World Clock

Mar 20, 2007

a way to turn excel into a world clock?

I am working for a company that has offices around the world, and I would like to see the time in all offices, when I am working in excel without using the internet (or spending monay on loads of wall clocks!)

View 10 Replies View Related

Subtract Hours From A Clock

Apr 13, 2014

im trying to subtract 19.2 hours from a clock and running into trouble.

formula in a1

a2 contains a date/time as 4-13-14 1:30 pm

a3 contains 19.2 (this is hours)

result should be a date/time like 4-12-14 9:10 am.

View 4 Replies View Related

Vba Coding For A Simple Clock

Sep 15, 2008

where can I get vba coding for a simple clock.

I would like the clock to be digital rather than analogue if possible

View 9 Replies View Related

Lockout Macro Clock

Nov 27, 2009

Can a group of cells or more be locked once they reached or passed a certain time frame and date that follows your PC clock, and can it be set to a time that you decide on in a macro. The other question, Can this lockout macro clock that was set to a pacific time frame can it stop people from altering their PC clock in anyway for e.g.; 'I tried to turn back the time but I got this message - "This cell is Locked due to your lateness".

View 9 Replies View Related

How To Get An Actual Live Clock

Nov 29, 2009

I am looking to get a Live Clock changing every minute..

Lets say I put the Total Time in the Cell A2 = 15 minutes and I have a Command Button next to it "Start"..

On the Click Event I want the Actual Time time-stamped at that moment in the Cell A3 and in Cell A4 the Time should keep on Ticking...

Can someone attach a file in Windows 2003 i.e .xls format and also explain the code if possible.

View 9 Replies View Related

Simple Timer / Clock On Userform VBA?

Feb 7, 2014

I need a Simple Timer on Userform which uses Excel files through VBA.

After getting User's choice, say the text "Ben", which is a portion of a name, my code collects data of all records having "Ben" from the Excel file, which has about 5000 records (still growing) and displays the resulting data of the selected records in Listview control. It is a lengthy code.

If a particular search has more records to display, then displaying them on listview control takes more time. So, I am using a progress bar to tell the user that work is being done.

Is it possible to run a timer to display something like a digital clock to show the user the elapsed time. In addition to the progress bar, the user will also see the running clock (or timer) and wait until all chosen records are displayed.

View 5 Replies View Related

Active Clock That Updates By The Minute

Feb 4, 2007

Is there anyway of getting an "Active Clock" in a cell.
I know the =now() thing, but this is not what I am looking for,
I would like to get a clock that updates by the minute, without having to select a cell, or make excel do a calculation.

View 9 Replies View Related

Counting Hours Before And Past 6 O' Clock

Nov 5, 2009

In cells B8 and C8 an in- and out-time are given, in E8 the time in between.
Now I'd like to calculate the number of hours before 6 o'clock and the number of hours past 6 o'clock.

The formulas I came up with work great in the first example, but fail in the second, because the start day is on another day.

View 9 Replies View Related

Create The Clock In Worksheet Through Macro

Mar 9, 2007

I would like to create the clock function.

This is my function name. - Clock()

If i put this function in Cell A1. Then from now onwards cell A1 will display system current time. It will keep showing the every seconds changes.

And clock will run itself independenly.

View 3 Replies View Related

How To Calculate Hours Worked Using 24hr Clock

Jan 28, 2014

Attached sheet, I am struggling with the formula that will add up the hours overtime worked per day when I enter start and finish times.

Standard working hours are :

mon to thurs 8 hrs per day 8m to 16.30 (with 30 mins unpaid break)
Friday 6 hrs per day
Saturday all hours are overtime

Hours Commited sheet.xlsx‎

View 4 Replies View Related

Running Clock In Excel Cell Directly

Jul 17, 2014

How we can put a running clock in Excel Cell directly .

View 2 Replies View Related

Ticking Clock By Seconds In Cell On Sheet1

Feb 4, 2013

I need to have a ticking clock by seconds in cell A1 on Sheet1.

This cannot have the current date associated with it. It needs to only show the time because I am using specific times in A4:A200 for employee report times, and in column B an IF statement

=IF(F4="x","Checked In",IF(A4>$A$1,"Early","Late"))

that show if an employee check in late. Column F will be used by our supervisor and they will simply mark an 'x' when the employee reports in for their shift.

I would like this macro to start automatically when a user opens the workbook, and stop when they close it.

View 1 Replies View Related

VBA - Macro Run When System Clock Changes - Forecasting With Live Feed?

Sep 21, 2013

I thought about using it for forecasting purposes. I might try to use it together with live data (temperature, seasonal patterns)... but if I graph it, it starts from left to right...

How to modify the code a bit...

VB:
Shift:=xlUp, CopyOrigin:=xlFormatFromRightOrDown

I tried to change the code, but it did not worked.

View 8 Replies View Related

Formula: Current Month Based On System Clock

Nov 30, 2009

Is There a formula for current Month based on system clock....

View 10 Replies View Related

How To Distribute 200 Items Into 14 Employees

May 19, 2014

I been working on excel sheet that will distribute 200 items between the employees that are available to work. I've attached a copy of the workbook. First I need to look at the quantity of employees I have working that day. Second Distribute the items to each one of the employees. Third give the first employee the first piece. Fourth give the next available piece to the last person with a zero piece in their list.

book8.zip‎

View 12 Replies View Related

Protect Workbook From Ex-employees

Sep 19, 2008

How can I protect by workbook from ex-employees and the competition from using (I am aware of the weak security measures Excel offers, but something is better than nothing)? Each worksheet is password protected to slow down novice Excel users. However, ex-employees know the password. I was thinking if there was a way to have a changing password (which only a couple people would know) or have the worksheet look for a hidden file on our network, that one of these methods (or another) might work.

View 6 Replies View Related

M-F Rotating Schedule With 7 Employees

Dec 9, 2013

After much searching today I've been unable to find a way to do this. All my searches resulted in some generic looking site looking to sell me some scheduling software.

I have a team of 7 people and I need one person to work a late shift each day of the business week. M-F

I would like a way to have the schedule automatically advance to the next person.

View 1 Replies View Related

Manual/Information On ADO

Sep 5, 2006

where is possible to get more detailed manual - reference - for using ADO in excel? Help in Excel doesnt content much information of ADO, I have tried to find other manual, but no results.

View 4 Replies View Related

Playing Audio Sound As Alert In Cell Triggered By Clock

May 7, 2013

I have a date base that is used as a job status board developed in excel that has locations, times, clock and other areas. What I am looking for is a way of playing a sound when the time approaches 5 min before the time in the excel cell that has been entered into the job status board...

View 3 Replies View Related

Run Loop 10 Times Then Stop Using A Timer Or System Clock To Restart

Jul 2, 2014

How do I run this loop 10 times ....Then using a timer or system clock to restart it.

Code:
Public Sub Workbook_Open()
Dim ws As Worksheet
Do
For Each ws In ThisWorkbook.Worksheets

[Code]....

View 1 Replies View Related

ADVERTISEMENT