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

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