Thread
:
Summing Time
View Single Post
#
8
Sweetpea60
Posts: n/a
I also cannot get Excel to sum time. I used the formula [h]:mm but it did
not work -the number is still displayed as 1:05 AM (for example). I'm not a
whiz at Excel so need more help.
Thanks,
Patti
"Nick Hodge" wrote:
JDT
Format the cells to [hh]:mm through Formatcells...numbercustom
--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS
"JDT" wrote in message
...
Hi,
I have a column with an amount of time entered. For ex:
1:38
2:05
3:00
0:45
6:27
etc.
When I try summing these time increments in another cell, the answer
is 0:00 if the total is over 24. I just need to be able to sum the
column and see how much total time there is--hours and minutes. I
know it's a simple solution.
Thanks.
Reply With Quote