View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default How do I enter degrees-minutes-seconds in a cell?

Format the cells for time using the custom format of [hh]:mm:ss and enter your dd-mm-ss as
dd:mm:ss. Then use regular addition or summing.

HTH,
Bernie
MS Excel MVP


"flsaltbass" wrote in message
...
I need to add several angle measurements in dd-mm-ss format. How do I enter
these into excel cells and have them work? I saw postings from a year ago but
couldn't get it to work.
Office excel 2003