View Single Post
  #3   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,

I should add that my suggestion related to Excel; I have no personal
experience of Works..

---
Regards,
Norman


"Norman Jones" wrote in message
...
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