Thread
:
Adding Time
View Single Post
#
5
Posted to microsoft.public.excel.worksheet.functions
paul
external usenet poster
Posts: 247
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
Reply With Quote
paul
View Public Profile
Find all posts by paul