How do I add times?

[frankie]

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.

[Dav]

Just sum them as normal sum(a3:a8)

Format custom format [h]:mm

Regards

Dav

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" <[email protected]> wrote in message
news:[email protected]...
>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.

[Daniel CHEN]

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" <[email protected]> wrote in message
news:[email protected]...
>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]

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