I need to figure time employees worked for payroll.

[Doug Crumley]

I used the formulas listed under time and date to no avail. Here is an example:
A D E
In Out Total Hrs
7:30 11:00
12:00 5:00 8.5 is the correct but I get anything but that. Please help. Thanks

 

[just_jon]

Found this; seems similar to your posting --

Timesheet-2.xls
	A	B	C	D	E
1	Weekof:06-Jan-03	TotalHours	Monday
2	EmployeeName	ThisWeek	In	Out	Hours
3	Namehere	23.83	6:54	10:05	3.18
4	(AfterBreak)		12:00	16:00	4.00
06-Jan-03

 

[ehs]

Doug,
I have been using this for a while for calculating hours of overtime on timesheets.On mine I have column "A" as day;"B" as Month;"C" Time From" and "D" as "To: Column "E" is the formula column. It doesn't matter what you put in for day and month as they are not calculated.(My sheets are monthly" The formula in Column "E" is:
=IF(D4="","",(24*(IF(D4<C4,D4+1-C4,D4-C4)))

The first If is use to keep the cell blank.
This uses the 24 hour clock, and works when you change days as well, example, from 21o hours to 03:00 hours.
Columns D & E are formatted "Time", but Column "E" is formatted "General", because I want the overtime hours to be in decimal, example: I want 2.5hours overtime, not 2:30.

Hope this helps. If you would like a copy of a working sheet, drop me an e-mail.

ehs
This message was edited by ehs on 2003-02-22 21:41
This message was edited by ehs on 2003-02-22 21:43

 

[ehs]

Sorry Doug,
I couldn't get the formula to view on the last response. Try again:
=IF(D4="","",(24*(IF(D4<C4,D4+1-C4,D4-C4))))

ehs
This message was edited by ehs on 2003-02-22 21:47

 

[ehs]

Doug,
For a general daily time sheet, try J-walk site at:
http://j-walk.com/ss/excel/files/timesht.htm
This is a free download, and might be what you need.
ehs

 

[maxflia10]

Doug,

Here's another

http://www.cpearson.com/excel/overtime.htm

 

[Barry Katcher]

Taking ehs's formula and adapting it for a double sign-in, sign-out (unpaid meal break). Assumes in-out-in-out are in cells C12:F12.

=IF(D12="","",(24*(IF(D12"<"C12,D12+1-C12,D12-C12))))+IF(F12="","",(24*(IF(F12"<"E12,F12+1-E12,F12-E12))))
This message was edited by Barry Katcher on 2003-02-22 22:33