More than 24 hours

[Bruce D]

I'm sure this has been asked before, but . . .
I'm trying to add this column of elapsed times (hh:mm):
0:20
2:02
0:30
3:16
2:19
1:47
1:25
2:06
2:02
0:12
3:45
2:35
2:55
0:10
0:15
1:00
2:11
1:00
0:49
0:29
0:42
1:19
The answer should be 32:59 (32 hours, 59 minutes), but I
keep getting 0:00:00
The column of elapsed times is formatted as Time 13:30.
I tried formatting the sum cell as Time 13:30, Custom
[h]:mm:ss, and also Time 37:50:55. None worked.

Any help greatly appreciated.

Bruce

 

[Bob Phillips]

Format [hh]:mm:ss should work

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Myrna Larson]

Selecting the time format that shows more than 24 hours (37 I think?) should
work. If your total is 0, it may mean that your "times" have been stored as
text rather than numbers. To check this, widen the column. If the data is left
aligned it's text, if right-aligned it's numeric.

To convert from text to numbers, Edit/Copy a *blank* cell. Select the cells
with the times and Edit/Paste Special and select the Values option. If you've
done it right, the alignment will change to right.

 

[Peter Atherton]

Bruce

you can try a custom format using days hrs and minutes.
Select your cell press ctrl +1,Numbertab, Custom and enter
dd:hh:mm this will result as 1:08:52

Alternatively convert the time to a number with an array
formula.
=sum(range*24) entered with CTRL + SHIFT + Enter will show
the answer as a decimal number.

regards
Peter Atherton
(e-mail address removed)

 

[Bruce D]

Myrna -

I think yours was the correct answer. The times are
beings stored as text.

I couldn't get your conversion technique to work: every
time I paste/special/value'd the blank cell to the time
cells, the times were delted. I tried to
paste/special/format, but that didn't work, either. Any
ideas?

Thanks.
Bruce

-----Original Message-----
Selecting the time format that shows more than 24 hours (37 I think?) should
work. If your total is 0, it may mean that your "times" have been stored as
text rather than numbers. To check this, widen the column. If the data is left
aligned it's text, if right-aligned it's numeric.

To convert from text to numbers, Edit/Copy a *blank* cell. Select the cells
with the times and Edit/Paste Special and select the Values option. If you've
done it right, the alignment will change to right.

I'm sure this has been asked before, but . . .
I'm trying to add this column of elapsed times (hh:mm):
0:20
2:02
0:30
3:16
2:19
1:47
1:25
2:06
2:02
0:12
3:45
2:35
2:55
0:10
0:15
1:00
2:11
1:00
0:49
0:29
0:42
1:19
The answer should be 32:59 (32 hours, 59 minutes), but I
keep getting 0:00:00
The column of elapsed times is formatted as Time 13:30.
I tried formatting the sum cell as Time 13:30, Custom
[h]:mm:ss, and also Time 37:50:55. None worked.

Any help greatly appreciated.

Bruce

.

 

[JulieD]

Hi Bruce

try edit / paste special - ADD

Cheers
JulieD

Myrna -

I think yours was the correct answer. The times are
beings stored as text.

I couldn't get your conversion technique to work: every
time I paste/special/value'd the blank cell to the time
cells, the times were delted. I tried to
paste/special/format, but that didn't work, either. Any
ideas?

Thanks.
Bruce

-----Original Message-----
Selecting the time format that shows more than 24 hours (37 I think?) should
work. If your total is 0, it may mean that your "times" have been stored as
text rather than numbers. To check this, widen the column. If the data is left
aligned it's text, if right-aligned it's numeric.

To convert from text to numbers, Edit/Copy a *blank* cell. Select the cells
with the times and Edit/Paste Special and select the Values option. If you've
done it right, the alignment will change to right.

I'm sure this has been asked before, but . . .
I'm trying to add this column of elapsed times (hh:mm):
0:20
2:02
0:30
3:16
2:19
1:47
1:25
2:06
2:02
0:12
3:45
2:35
2:55
0:10
0:15
1:00
2:11
1:00
0:49
0:29
0:42
1:19
The answer should be 32:59 (32 hours, 59 minutes), but I
keep getting 0:00:00
The column of elapsed times is formatted as Time 13:30.
I tried formatting the sum cell as Time 13:30, Custom
[h]:mm:ss, and also Time 37:50:55. None worked.

Any help greatly appreciated.

Bruce

.

 

[Guest]

Thanks, Julie, that works!

I also found out later you can multiply by 1.

BruceD

-----Original Message-----
Hi Bruce

try edit / paste special - ADD

Cheers
JulieD

Myrna -

I think yours was the correct answer. The times are
beings stored as text.

I couldn't get your conversion technique to work: every
time I paste/special/value'd the blank cell to the time
cells, the times were delted. I tried to
paste/special/format, but that didn't work, either. Any
ideas?

Thanks.
Bruce

-----Original Message-----
Selecting the time format that shows more than 24

hours
(37 I think?) should

work. If your total is 0, it may mean that

your "times"
have been stored as

text rather than numbers. To check this, widen the column. If the data is left
aligned it's text, if right-aligned it's numeric.

To convert from text to numbers, Edit/Copy a *blank* cell. Select the cells
with the times and Edit/Paste Special and select the Values option. If you've
done it right, the alignment will change to right.

On Thu, 5 Aug 2004 14:08:01 -0700, "Bruce D"

I'm sure this has been asked before, but . . .
I'm trying to add this column of elapsed times (hh:mm):
0:20
2:02
0:30
3:16
2:19
1:47
1:25
2:06
2:02
0:12
3:45
2:35
2:55
0:10
0:15
1:00
2:11
1:00
0:49
0:29
0:42
1:19
The answer should be 32:59 (32 hours, 59 minutes),

but
I

keep getting 0:00:00
The column of elapsed times is formatted as Time 13:30.
I tried formatting the sum cell as Time 13:30, Custom
[h]:mm:ss, and also Time 37:50:55. None worked.

Any help greatly appreciated.

Bruce

.

.

 

[Myrna Larson]

EGADS!!! I forgot to tell you to check the ADD option. Glad Julie was able to
correct my error.

Thanks, Julie, that works!

I also found out later you can multiply by 1.

BruceD

-----Original Message-----
Hi Bruce

try edit / paste special - ADD

Cheers
JulieD

Myrna -

I think yours was the correct answer. The times are
beings stored as text.

I couldn't get your conversion technique to work: every
time I paste/special/value'd the blank cell to the time
cells, the times were delted. I tried to
paste/special/format, but that didn't work, either. Any
ideas?

Thanks.
Bruce

-----Original Message-----
Selecting the time format that shows more than 24 hours
(37 I think?) should
work. If your total is 0, it may mean that your "times"
have been stored as
text rather than numbers. To check this, widen the
column. If the data is left
aligned it's text, if right-aligned it's numeric.

To convert from text to numbers, Edit/Copy a *blank*
cell. Select the cells
with the times and Edit/Paste Special and select the
Values option. If you've
done it right, the alignment will change to right.

On Thu, 5 Aug 2004 14:08:01 -0700, "Bruce D"

I'm sure this has been asked before, but . . .
I'm trying to add this column of elapsed times (hh:mm):
0:20
2:02
0:30
3:16
2:19
1:47
1:25
2:06
2:02
0:12
3:45
2:35
2:55
0:10
0:15
1:00
2:11
1:00
0:49
0:29
0:42
1:19
The answer should be 32:59 (32 hours, 59 minutes), but
I
keep getting 0:00:00
The column of elapsed times is formatted as Time
13:30.
I tried formatting the sum cell as Time 13:30, Custom
[h]:mm:ss, and also Time 37:50:55. None worked.

Any help greatly appreciated.

Bruce

.

.