I guess I am not being clear as to what I want to do. I take each card and
enter the times in and out into excel for the whole week for each day. I
need each cell that I enter the time into to be converted to military time
for the hours and the minutes are divided by 60 to get the # to add/subract.
So I would enter in @ 6:59am out for lunch 12:00pm back @12:30pm out @
4:25pm. I need the time converted to look like this in @ 6.98 out @12.00
back @ 12.50 out at 16.42 to get total hours of 8.94. That is adding 12 to
pm hours and dividing all minutes by 60 (actual minutes in an hour). I want
to be able to enter using a decimal instead of a colon in the time. What I
do now is take the card and change each punch by / the minutes by 60 by hand
and enter the result in the spreadsheet. I am trying to eliminate having to
do the division by hand and then enter to excel. I hope this helps. Thank
you all.
--
Kim


"Myrna Larson" wrote:

Excel times are stored as a fraction of a day. To convert that to hours, you
just multiply by 24. So, if you want the result in decimal hours, change the
formula to

=(E7-D7+E6-D6)*24

and format the cell as General. Or leave the formula as-is, and in the cell
where you calculate the pay using an hourly rate, multiply by 24 in that
formula. i.e. if the formula in F7 is =E7-D7+E6-D6, and you calculate the pay
in G7, the formula for G7 is =F7*24*<hourly pay rate



On Mon, 19 Sep 2005 14:21:07 -0700, Kim wrote:

My spreadsheet is set up like this: E7 is in time D7 is out time E6 is in
time and D6 is out time. The formula is E7-D7+E6-D6 to get the total hours
worked. Our time cards are printed in regular format. I need to convert
this regular time to decimal/military time to get total hours worked. I am
looking for a formula to change the hours and minutes to decimal/military
time. 1.38 = 13.63. hours +12 and minutes /60. Can I enter the hours with
decimals instead of colons and convert to decimal/military time? I am sure I
am way overthinking this and making it more difficlut than it needs to be.
Any help is sure appreciated.