View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Excel and Works should add hours and minutes over 24, no seconds

Hi Upward Bound,

Try using the custom format:

[h]:mm

---
Regards,
Norman


"Upward Bound" <Upward wrote in message
...
Excel and Works should allow users to add hours and minutes over 24
without
including seconds. As it appears now, you have to type in hours and
minutes
over 24 manually if you don't want the seconds to show. For example:
134:50. Excel only allows 134:50:00. Works doesn't allow anything except
in
text format.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...el.programming