View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected] bplumhoff@gmail.com is offline
external usenet poster
 
Posts: 136
Default Date format to decimal format?

Hello Michael,

=--TEXT(A1,"[h].mm")

HTH,
Bernd