ok...I'm really confused. I'm pretty simple and need real simple instructions.
I open a new excel sheet...
then I type in 2.07 (yes 2 point 07) in the first cell (A1)
the next cell down (A2) I type in .30 (point 30)
the next cell down (A3) I type in .35 (point 35)
the next cell down (A4) I type in 1.10 (1 point 10)
the next cell down (A5) I type in .10 (point 10)
the next cell down (A6) I type in .59 (point 59)
the next cell down (A7) I type in .15 (point 15)
Now in the next cell down (A8) I use the Sum Icon on the tool bar menu
and I get 4.66...
But since the above numbers represent hours and minuets turned in daily,
I need to convert the 4.66 into 5:46 which is the actual hours worked for
that week.

In my thinking, if I used counting beads, then for every 60 beads it would
become 1 hour, but I would have to count out the beads continuously until the
end? that's a lot of beads... Can you help me get it to work in excel?


"David Biddulph" wrote:

It should work, so I guess that you've got at least one of your data values
wrong.

It may be easier for us to help you if you tell us what answer you get.
--
David Biddulph

"JR" wrote in message
...
I used the custom format "h:mm" in the cells where I put the times and when
I
type in the numbers it turns to 0:00...and then I typed it in as 2:07 etc
and
formated the cell for where the total is to be to "[h]":mm and it returns
a
different answer than 5:46??? What am I doing wrong?

"Max" wrote:

Enter the times in "h:mm" format,
viz. input in A1:A7 as:

2:07
0:30
0:35
1:10
0:10
0:59
0:15

Then just sum it up in A8: =SUM(A1:A7)
Format A8 as Custom, Type: [h]:mm
(with the square brackets around the "h")
to enable it to rollover 24 hours, if necess.

For the sample data, A8 will return: 5:46
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"JR" wrote:
Example: 2 hrs 7 min plus 30 min plus 35 min plus 1 hr 10 min plus 10
min
plus 59 min plus 15 min??? I know the answer is 5 hours and 46 min but
how
can I get excel to give me this answer?