Excel and Works should add hours and minutes over 24, no seconds
 

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

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

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

Excel and Works should add hours and minutes over 24, no secon
 

Norman,
Thanks for the suggestion. I hadn't realized I could type a formula in
the Custom section that wasn't already there. It works great.

Ed Rice aka Upward Bound


"Norman Jones" wrote:

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