Thread
:
Excel and Works should add hours and minutes over 24, no seconds
View Single Post
#
3
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,
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
Reply With Quote
Norman Jones
View Public Profile
Find all posts by Norman Jones