Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default 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
 
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 09:52 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"