View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Enter Standard Time for H:MM Formula

the comma will still give problems anywhere comma isn't the decimal
separator.

the Danish word for Hour is Time? Interesting.

--
Regards,
Tom Ogilvy


"excelent" wrote:

Sry. was in dannish
=(HOUR(A2-A1+(A1A2))&","&(MINUTE(A2-A1+(A1A2))/60*100))*1



"Benz" skrev:

It gives me an error message when I enter this.

"excelent" wrote:

Unless u realy want minutes as dec.
=(TIME(A2-A1+(A1A2))&","&(MINUTE(A2-A1+(A1A2))/60*100))*1