Thread: Adding Time
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
romelsb romelsb is offline
external usenet poster
 
Posts: 117
Default 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