Adding time
I have a list of time spent per call on the phone. It is in the format
0:00:00:00 Where you have days, hours, minutes, seconds I have trimmed this to hours, minutes and seconds. However when I use the Sum() function to add some of them up I get the value 0:00:00, if I use the =A1:A4 option I get a #Value error, but if I go A1+A2+A3 etc... I get the right answer. What am I dong wrong? I have set the call format to time, but it doesnt help. W want to pull the information into a pivot-table but with the sum() function not working I am having problems. Can anybody help please? |
Adding time
Does this help? http://www.contextures.com/xlfaqDat.html#AddTime Can you give an example of where the SUM() time differs from adding specific cell names? -- Special-K ------------------------------------------------------------------------ Special-K's Profile: http://www.excelforum.com/member.php...fo&userid=7470 View this thread: http://www.excelforum.com/showthread...hreadid=563695 |
All times are GMT +1. The time now is 07:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com