Summing times

Helen · May 1st, 2002, 06:26 AM

I have a list of times:
8:05
8:05
8:05
8:05
5:40

When I sum these it comes back with 14, but it should be 38.

Please help!

MattB · May 1st, 2002, 06:34 AM

Change the format of the summation cell to Custom> [h]:mm:ss

s-o-s · May 1st, 2002, 06:35 AM

Excel has calculated 38 but it shows the time formating being 38-24hrs = 14

If you have another cell which = then sum of your times *24 It will give you 38. Excel treats Times as a fraction of a day.

To see reformat your dates as numbers and they will all show as 0.33 approx.

May 1st, 2002, 06:35 AM	#3
s-o-s Board Regular Join Date: Apr 2002 Location: Kissimmee, Florida Posts: 384	Excel has calculated 38 but it shows the time formating being 38-24hrs = 14 If you have another cell which = then sum of your times *24 It will give you 38. Excel treats Times as a fraction of a day. To see reformat your dates as numbers and they will all show as 0.33 approx. __________________ Hope This Helps. Sean. Digest of Homes WinXP, XL XP

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 1st, 2002, 06:26 AM	#1
Helen Board Regular Join Date: Feb 2002 Posts: 103	I have a list of times: 8:05 8:05 8:05 8:05 5:40 When I sum these it comes back with 14, but it should be 38. Please help!

May 1st, 2002, 06:34 AM	#2
MattB Board Regular Join Date: Mar 2002 Posts: 62	Change the format of the summation cell to Custom> [h]:mm:ss