Adding Time

[bob]

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

 

[romelsb]

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

 

[Bob Phillips]

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

--

HTH

Bob Phillips

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

 

[daddylonglegs]

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

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

 

[paul]

custom format [h]:mm:ss

 

[romelsb]

Bob says...."I'd also like to add

times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63)."

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

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

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

 

[bob]

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

Bob says...."I'd also like to add

times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63)."

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

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

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

 

[David Biddulph]

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

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).

Bob says...."I'd also like to add

times together (e.g., 33:33:33 plus 30:30:30 = 63:63:63)."

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

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

:

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