K
Kim
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 dividing 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 am hoping to enter a
formula in the next cell that converts 12:30 to 12.50 and 4:25 to 4.50
(notice the colon and decimal). Is this possible
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 dividing 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 am hoping to enter a
formula in the next cell that converts 12:30 to 12.50 and 4:25 to 4.50
(notice the colon and decimal). Is this possible