I am preparing a time sheet and am inserting times as hh:min I have 5 entries
in a column and and as soon as I try to sum up the times, it messes up. Don't
get the accurate time. I tried this sum (A3:A8)*24 as suggested by excel but
it doesnt work.
8:30
8:03
8:35
8:36
7:34
I want to add this up.Please help.

Just sum them as normal sum(a3:a8)

Format custom format [h]:mm

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=544743

Your time 8:30 is for 8:30 AM OR 8 hours and 30 minutes?
If it is for 8:30AM, then why do you want to sum up those times?

If it is for 8 hours and 30 minutes, then use the following array functions
(end w/ Ctrl+Shift+Enter)
=SUM(HOUR($A$1:$A$5))+SUM(MINUTE($A$1:$A$5))/60

which will give you 41.30 hours.



--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"frankie" wrote in message
...
I am preparing a time sheet and am inserting times as hh:min I have 5
entries
in a column and and as soon as I try to sum up the times, it messes up.
Don't
get the accurate time. I tried this sum (A3:A8)*24 as suggested by excel
but
it doesnt work.
8:30
8:03
8:35
8:36
7:34
I want to add this up.Please help.

Hi

Format the total cell as [hh]:mm and see if that gives you what you want.
This will stop the hours from rolling over into days.

Andy.

"frankie" wrote in message
...
I am preparing a time sheet and am inserting times as hh:min I have 5
entries
in a column and and as soon as I try to sum up the times, it messes up.
Don't
get the accurate time. I tried this sum (A3:A8)*24 as suggested by excel
but
it doesnt work.
8:30
8:03
8:35
8:36
7:34
I want to add this up.Please help.

What happens when you add them up.

Maybe using a custom format of:
[hh]:mm

would be sufficient.


frankie wrote:

I am preparing a time sheet and am inserting times as hh:min I have 5 entries
in a column and and as soon as I try to sum up the times, it messes up. Don't
get the accurate time. I tried this sum (A3:A8)*24 as suggested by excel but
it doesnt work.
8:30
8:03
8:35
8:36
7:34
I want to add this up.Please help.

--

Dave Peterson