time clock break down

September 21, 2009 at 14:20:43
Specs: Windows XP
Is there formula I can put in excell to to clock in clock out time for payroll? In 8:12 out 17:47 -.45 lunch =

See More: time clock break down

Report •


#1
September 21, 2009 at 14:56:28
Hi,

This simple macro will put the current time into the active cell

Sub Time_Now()
'Routine to Enter current time in active cell
'Change format as required
With ActiveCell
    .Value = Time
    .NumberFormat = "hh:mm"
End With
End Sub

Put the macro in a standard module in the Personal.xls workbook

The easiest way to use this is to put a button on a toolbar and link it to this macro. When you have selected a cell, clicking the button will put the time in the cell.

A better way is to add an insert time option to the right click cell shortcut menu, but this is a little more complicated.

Note that this macro only puts the time in the cell.

If you need date as well it can easily be modified.

The time format is 24hrs e.g., 16:10
but it can be changed in the format line in the macro.

To calculate hours, if start time is in A2 and finish time in B2
In C2 put =B2-A2

You can add the break duration
Enter it in D2 as 0:45
The formulas in C2 and E2 are also shown

	A	B	C	D	E
1	Start	Finish	Total	Break	Worked
2	8:00	17:47	9:47	0:45	9:02
			=B2-A2		=C2-D2

This calculation will not work if finish time is after midnight, but there are ways of dealing with that, if it is an issue.

Just ask.

Regards


Report •

#2
September 21, 2009 at 15:17:00

Report •

#3
October 11, 2009 at 16:18:26
hi,
sorry for bumping and stealing this topic,
but I think my question is related to this topic and since I'm newcomer here please forgive me ;)

the problem :
I am developing a time tracking s/w for a time clock system and problem starts when the employees start their work suppose at 10pm and their job will finish at 3am next day
this time zone spread into two different days.
like he starts his job at Monday 10pm and he will finish it at Tuesday 3am.

I am not able to calculate this time period correctly .
I need some ideas about this problem or any existed algorithm according to that will be welcomed.
and what is the other companie's solution as regards of this problem?
how do u they solve it?


regards.


Report •

Related Solutions

#4
October 11, 2009 at 17:41:08
Hi,

Can I ask that you start a new thread.

It makes it easier to track topics.

Use a title that describes the issue such as Excel time calculation after midnight.

In the body of the question be as specific as you can be about what you need to do. What inputs you have and what outputs you need

In the meantime look at Response #1 in
this thread.

Regards


Report •


Ask Question