# 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.

## 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

## 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?

## 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.

## 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.

## 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.

## 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

## 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.

## 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].

## 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‎

## 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".

## 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.

## 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.

## 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

## 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..............

## 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.

## 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()

## 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.

## 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.

## Countdown Clock

Dec 31, 2007

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

## 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.

## 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!)

## 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.

## 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

## 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".

## 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.

## 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.

## 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.

## 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.

## 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.