MS Excel Help: Calculating Time

[Reephdweller]

One of the things I have do now at work is keep track of peoples time. For instance, when they go to lunch and come back from lunch the employees need to scan in and out with their badges. So now I have the pleasure of having to watch the time when I do the payroll in the morning. If someone goes beyond the time they are allotted we have to address it with them. However to make it easier I'd like to find a way in excel to calculate the time in a formula, as in

Clock out time 12:00
Clock in time 1:00
= 1:00 hour

I've been trying to do this without much success and I'm sure Excel can do it, but I can't figure out how. Any help would be appreciated.

<center><IMG SRC="http://www.chaoticconcepts.com/randomizer/random.php?uid=3">
Reefy's website... (http://www.osirusonline.com/)</center>
<font size="1" color="red">
<center>Check out The Ron and Fez Show Logs...UPDATED!!!!! (http://www.osirusonline.com/ronfez.htm)</center>
<marquee behavior=alternate bgcolor="#FFFFFF">Right now you could care less about me...
but soon enough you will care, by the time I'm done</marquee> </font>

[Snoogans]

youd have to make a collumn for time worked, and time not working like lunch. then you can make a formula to subtract the collum of time out from time in, and it should work

<img src="http://scripts.cgispy.com/image.cgi?u=Snoogans194">
GO SAWX!!!!!
The worst choke job in the history of sports Snoogans 1, Monitor 0

[Snoogans]

example:
Suzie 7 hours (work time) 1 hour (break time)

then set the form to subtract 3 from 2, you have to put in all the numbers, but at least you dont have to think

<img src="http://scripts.cgispy.com/image.cgi?u=Snoogans194">
GO SAWX!!!!!
The worst choke job in the history of sports Snoogans 1, Monitor 0

[JPMNICK]

reef -

do you get an excel sheet with data in it already? like from the scaning machine?

did you try to do everythign in miltary time so you do not worry about AM or PM



http://home.comcast.net/~nickcontardo/rfnetjp.jpg
Thanks to Reef for my sig. You rock

[HBox]

Just switch everybody over to military time. Problem solved.



Who lives in a body bag under the sea?

[badorties]

military time would solve a lot of the quirks ... also formatting the cells (to HH:MM:SS) might help out as well ...



<img src="http://scripts.cgispy.com/image.cgi?u=badorties"><br>

+|+|+|+|+|+|+|+|+|+|+|+|+|+|+

[Reephdweller]

do you get an excel sheet with data in it already? like from the scaning machine?

did you try to do everythign in miltary time so you do not worry about AM or PM


It's a web based payroll program the company uses. When the employee scans his or her badge it records it in the time clock which sends the data into the system. So that the next day when I do the payroll I see the clock-in when they come in. The clock-out when they go to lunch, the clock-in when they get back, and then ultimately the clock-out when they leave for the day. Unfortunately some people go to lunch at various weird times of the day like 14:34-15:04 or whatever, whether they were caught up on a call or whatever. But the thing is, instead of me trying to figure out what the times add up to when it's not so clear how long they took I'd like to enter the numbers into a spreadsheet and have it tell me how long they took.

The web-based program automatically tells us how long their hours were for the day, but it doesn't give me an idea of the lunch times they took. For most people it's pretty easy to tell, but for those where it's not so easy I'd like to be able to use excel to figure it out quickly.

<center><IMG SRC="http://www.chaoticconcepts.com/randomizer/random.php?uid=3">
Reefy's website... (http://www.osirusonline.com/)</center>
<font size="1" color="red">
<center>Check out The Ron and Fez Show Logs...UPDATED!!!!! (http://www.osirusonline.com/ronfez.htm)</center>
<marquee behavior=alternate bgcolor="#FFFFFF">Right now you could care less about me...
but soon enough you will care, by the time I'm done</marquee> </font>

[KC2OSO]

This (http://www.techonthenet.com/excel/questions/time_calcs.htm) do it?

http://www.njmikec.com/Fester1.jpg