Thread: How do I add a duration time value and a clock time value?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sueb262 sueb262 is offline
external usenet poster
  
Posts: 2
Default How do I add a duration time value and a clock time value?
I have a column containing cells formatted with the "1:30 PM" option (clock
time), and a column containing cells formatted with the "37:30:55" option
(duration time). I know I can jump through several hoops to extract and add
the various segments to get a new clock time, but I can't believe it's that
difficult. This MUST be a relatively common need, and surely I'm making it
more convoluted than it is, but I can't find the elegant way.
Reply With QuoteReply With Quote