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
|