View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips[_3_] Bob Phillips[_3_] is offline
external usenet poster
 
Posts: 2,420
Default add 10,0015:15 hours to 03:53 Hours to a total time

Even in ne formula it works

=K2+"5000:00:00"+"5000:00:00"

--
__________________________________
HTH

Bob

"Bob Phillips" wrote in message
...
Add it in two stages, 5000 and then another 5000.

--
__________________________________
HTH

Bob

"Alan" wrote in message
...
when adding a hour number larger that 10,000 to another time number the
formula will not give a correct answer. Tried several time formats and
nothing worked. I need a format that is (HH,HHH:MM).