View Single Post
  #7   Report Post  
Ron Rosenfeld
 
Posts: n/a
Default

On 1 Jan 2005 07:16:18 -0800, "Paul" wrote:

This explanation of the necessity to divide by 24 is very clear.
Can someone post an explanation of the function of the brackets in the
time format [hh]:mm.


As I wrote, it keeps the hours from rolling over to zero every 24 hours.
Perhaps this example will make it more clear:

Value Format Display
=12/24 d:h:m 0:12:0
=12/24 h:m 12:0

1.5 d:h:m 1:12:0
1.5 h:m 12:0
1.5 [h]:m 36:0


--ron