Adding Time
 

I'd like to enter a time in hours, minutes, and seconds that is beyond the
standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also like to add
times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63).

The only timestamps among Excel's format options seem to be AM and PM, which
limits the time to a range of 00:00:00 through 24:00:00. I want to go higher
than 24:00:00.

Can anyone help? Thanks.

Bob

Adding Time
 

Hey Bob...thats a real one...Ill standby in this thread also...we wait for
the most helpful answer....hope u dont mind...

"bob" wrote:

I'd like to enter a time in hours, minutes, and seconds that is beyond the
standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also like to add
times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63).

The only timestamps among Excel's format options seem to be AM and PM, which
limits the time to a range of 00:00:00 through 24:00:00. I want to go higher
than 24:00:00.

Can anyone help? Thanks.

Bob

Adding Time
 

format all the cells as [h]:mm:ss

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"bob" wrote in message
...
I'd like to enter a time in hours, minutes, and seconds that is beyond the
standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also like to
add
times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63).

The only timestamps among Excel's format options seem to be AM and PM,
which
limits the time to a range of 00:00:00 through 24:00:00. I want to go
higher
than 24:00:00.

Can anyone help? Thanks.

Bob

Adding Time
 

Custom format your cells as [hh]:mm:ss

This allows "elapsed time" and can go beyond 24 hours

"bob" wrote:

I'd like to enter a time in hours, minutes, and seconds that is beyond the
standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also like to add
times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63).

The only timestamps among Excel's format options seem to be AM and PM, which
limits the time to a range of 00:00:00 through 24:00:00. I want to go higher
than 24:00:00.

Can anyone help? Thanks.

Bob

Adding Time
 

custom format [h]:mm:ss
--
paul

remove nospam for email addy!



"romelsb" wrote:

Hey Bob...thats a real one...Ill standby in this thread also...we wait for
the most helpful answer....hope u dont mind...

"bob" wrote:

I'd like to enter a time in hours, minutes, and seconds that is beyond the
standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also like to add
times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63).

The only timestamps among Excel's format options seem to be AM and PM, which
limits the time to a range of 00:00:00 through 24:00:00. I want to go higher
than 24:00:00.

Can anyone help? Thanks.

Bob

Adding Time
 

Bob says...."I'd also like to add
times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63)."

"daddylonglegs" wrote:

Custom format your cells as [hh]:mm:ss

This allows "elapsed time" and can go beyond 24 hours

"bob" wrote:

I'd like to enter a time in hours, minutes, and seconds that is beyond the
standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also like to add
times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63).

The only timestamps among Excel's format options seem to be AM and PM, which
limits the time to a range of 00:00:00 through 24:00:00. I want to go higher
than 24:00:00.

Can anyone help? Thanks.

Bob

Adding Time
 

That works. Thanks.

I'd also like to convert the accumulated time (e.g., 58:12:10) into total
minutes as a whole number and fraction (e.g., 3492.16, which equals 58 hours
times 60 minutes plus 12 minutes plus 10 seconds).

Any thoughts?

Thanks,
Bob

"romelsb" wrote:

Bob says...."I'd also like to add
times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63)."

"daddylonglegs" wrote:

Custom format your cells as [hh]:mm:ss

This allows "elapsed time" and can go beyond 24 hours

"bob" wrote:

I'd like to enter a time in hours, minutes, and seconds that is beyond the
standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also like to add
times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63).

The only timestamps among Excel's format options seem to be AM and PM, which
limits the time to a range of 00:00:00 through 24:00:00. I want to go higher
than 24:00:00.

Can anyone help? Thanks.

Bob

Adding Time
 

=A1*24*60
and format as number or general.
--
David Biddulph

"bob" wrote in message
...
That works. Thanks.

I'd also like to convert the accumulated time (e.g., 58:12:10) into total
minutes as a whole number and fraction (e.g., 3492.16, which equals 58
hours
times 60 minutes plus 12 minutes plus 10 seconds).

"romelsb" wrote:

Bob says...."I'd also like to add
times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63)."

"daddylonglegs" wrote:

Custom format your cells as [hh]:mm:ss

This allows "elapsed time" and can go beyond 24 hours

"bob" wrote:

I'd like to enter a time in hours, minutes, and seconds that is
beyond the
standard AM and PM formats (e.g., 45:56:06 or 34:10:34). I'd also
like to add
times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63).

The only timestamps among Excel's format options seem to be AM and
PM, which
limits the time to a range of 00:00:00 through 24:00:00. I want to go
higher
than 24:00:00.

Can anyone help? Thanks.

Bob