trying to calculate time

  • Thread starter Thread starter pwf3
  • Start date Start date
P

pwf3

Using Excel 97 and am trying to make a simple time card that wil
calculate employees hours. I want to enter: Time in, Lunch out, Lunc
in, Time Out--then have excel show me how many hours they worked. I'v
had some success with this but the SUM function doesn't always seem t
add time correctly. And--this is where I have NO clue what to do--ho
do you change a number that is formated as time into a number that
can calculate with. I'm trying to get

hours x rate = total then add totals for a weekly total

thanks for your help
 
Hi pwf3!

Formatting the SUM cell [hh]:mm:ss will probably solve this problem.

As far as multiplying time by an hourly rate is concerned, note that
time is recorded by Excel as a decimal part of a day so use:

TotalTime*24*HourlyRate


For other time sheet stuff see:

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


Dave McRitchie
http://www.mvps.org/dmcritchie/excel/datetime.htm


With a downloadable employee timesheet available at:

John Walkenbach:
http://j-walk.com/ss/excel/files/timesht.htm

The John Walkenbach reference shows a pretty picture of the output and
the downloadable version has an unprotect sheet option button that
allows you to see all the essential formulas in operation. You will
need to have security settings on Medium or Low before you can open a
fully operational version as there is some VBA code. That code is
viewable but not really necessary in terms of your being able to see
how the formulas work (and it has value in it’s own right as an
example of some VBA code techniques).

As far as multiplying time by an hourly rate is concerned, note that
time is recorded by Excel as a decimal part of a day so use:

TotalTime*24*HourlyRate
 
Back
Top