How to format time in decimal format & calculate time

C

Cheyenne

I used the CUSTOM function as [mm:ss], but it's not working as I thought that
it would. What I want is a user to type in the number of dictated minutes
they typed for a job; i.e: 2:30 (2 min. 30 sec) and have it stay in that
format as decimal after entered. However, I'm getting results of 12:00 for
that example when using the format stated above? I also want to add these
dictated minutes and have the result calculated in H:MM:SS. HELP? I've tried
everything!

[Post for Microsoft: I couldn't execute this NEW post in the EXCEL
discussion group as it kept giving me a posting error and I tried several
times]

----------------
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/com...b-482f65f4fc8e&dg=microsoft.public.excel.misc
 
S

Sheeloo

If you want to enter in decimal then get your users to enter 2.5 for 2
minutes and 30 seconds.

You can add them up and divide the result by 24*60 and format the cell as
[hh]:mm:ss tp get the total time in hours/minutes and seconds.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top