How do I add times?

F

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.
 
D

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
=================================
 
G

Guest

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.
 
D

Dave Peterson

What happens when you add them up.

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

would be sufficient.
 
Top