Prev Previous Post   Next Post Next
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 618
Default 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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding Time Function Joe Excel Worksheet Functions 4 September 27th 06 04:27 PM
adding a code to calculate how much time is lost vwghia21 Excel Discussion (Misc queries) 3 September 6th 06 08:54 AM
Adding time Ken Davie Excel Worksheet Functions 10 June 5th 06 06:54 PM
what is the formula for adding up time intervals? thinkrabbit Excel Discussion (Misc queries) 4 May 24th 06 06:57 AM
adding in time formats rvnwdr Excel Discussion (Misc queries) 1 May 31st 05 11:38 PM


All times are GMT +1. The time now is 05:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"