View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
Dave
 
Posts: n/a
Default Hours and minutes display as date in formula box



"Ron Rosenfeld" wrote:

On 6 Jan 2006 04:26:30 -0800, "Ken Johnson" wrote:

Hi Ron,
I meant to ask...
What is the difference between [h]:mm and h:mm?
Ken Johnson


Without the brackets around the h, the h will show h mod 24, so 93:11 would
show as 21:11


--ron
It works. Thanks to all of you.