Timesheets

[karebear]

hello everyone!

I'm trying to create a timesheet that is simple to use by an employee. Employees at this company work overnight shifts, most from 630 pm to 130 am. is there a function i can use or something that will figure out how many hours worked if such information is entered by the employee? how do i go about creating such a thing? and will it also work for regular hours that dont bleed over into the next day? i've been pouring over websites trying to find an answer, but i cant seem to find one. any help would be greatly appreciated!

 

[Paul B]

Have a look at http://www.cpearson.com/excel/overtime.htm

 

[karebear]

thanks!

 

[IML]

slow, slow, slow, sorry.


With a starting time in A1 and ending time in B1, you could simply use
=B1-A1
This would mean time would have be entered with the date to for those working over midnight. If you just want to enter time, use
=B1+(B1<A1)-A1
this will work for your overnight situation as long you do not have any working over 24 hours.

On 2002-02-22 13:53, karebear wrote:
hello everyone!

I'm trying to create a timesheet that is simple to use by an employee. Employees at this company work overnight shifts, most from 630 pm to 130 am. is there a function i can use or something that will figure out how many hours worked if such information is entered by the employee? how do i go about creating such a thing? and will it also work for regular hours that dont bleed over into the next day? i've been pouring over websites trying to find an answer, but i cant seem to find one. any help would be greatly appreciated!

This message was edited by IML on 2002-02-22 14:07

 

[Aladin Akyurek]

See also:

http://mrexcel.com/board/viewtopic.php?topic=31&forum=2&6