Thread
:
Excel and Works should add hours and minutes over 24, no seconds
View Single Post
#
2
Posted to microsoft.public.excel.programming
Norman Jones
external usenet poster
Posts: 5,302
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
Reply With Quote
Norman Jones
View Public Profile
Find all posts by Norman Jones