Hi,
I have a column with hours in the following format HH:MM:SS, that looks like this:
12:16:00
1:35:00
1:35:00
12:47:00
12:46:00
12:51:00
4:33:00
4:05:00
12:54:00
3:19:00
3:19:00
I am trying to add the sum total of all hours, but its not working.
I have my column formatted as time -> 37:30:55
Any suggestions?
Thanks.
Last edited by nmss18; 02-18-2009 at 01:53 PM.
What is it doing?
As in how is it not working.
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
When I use the autosum function I get this:
=SUM()
You need =sum(<all the hours>) and to format the result cell "[hh]:mm:ss" (N.B. square brackets)
HTH
I am not too sure I understood what you are suggesting. I added a small attachment.
Could you show me what you mean?
thanks.
Your column is formatted correctly but your times are stored as text.
Type 1 into a cell
copy it
select your times
edit->paste special->multiply
hey presto, your times become times and the world has meaning once more
HTH
Yep. It works. thanks for the tip!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks