Thread: add 10,0015:15 hours to 03:53 Hours to a total time
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Alan Alan is offline
external usenet poster
  
Posts: 152
Default add 10,0015:15 hours to 03:53 Hours to a total time
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).
Reply With QuoteReply With Quote