Thread: Summing Time
View Single Post
  #7   Report Post  
JDT
 
Posts: n/a
Default

On Thu, 3 Feb 2005 19:08:28 -0000, "Nick Hodge"
wrote:

JDT

No...go to the menu option Format

Then Cells...

The Number Tab

The bottom of the list is an entry called Custom

Click on this

A list with a box at the top will appear

In the box type [hh]:mm or [h]:mm

The difference is with 1:00 hour the first one will show 01:00 the second
1:00

--
HTH
Nick Hodge


OK, thanks. I wasn't typing anything in; I was just looking for the
drop down box. I didn't know you could type-in. Thanks again.