Tom's Guide | Tom's Hardware | Tom's Games

Computing.Net > Forums > Office Software > excel-multiply time

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

excel-multiply time

Reply to Message Icon

Name: ndosh
Date: April 5, 2009 at 23:52:21 Pacific
OS: Windows XP
Subcategory: Microsoft Office
Comment:

salam
i need to multi hours as following
salary=125:50:20 *10 lyd
if i apply this equation, answer will give
5:50:20 * 10
Any advice is greatly appreciated! Thanks!



Sponsored Link
Ads by Google

Response Number 1
Name: DerbyDad03
Date: April 6, 2009 at 07:02:05 Pacific
Reply:

What does 125:50:20 mean?

Hours:Mins:Secs?



0

Response Number 2
Name: Mike (by mmcconaghy)
Date: April 6, 2009 at 07:51:57 Pacific
Reply:

I believe you have the cell formatted incorrectly, try:

[H]:MM:SS

You will find it under Custom Format.

MIKE

http://www.skeptic.com/


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


Avoid 0 & #DIV/0! Office 2000



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links
Ads by Google


Results for: excel-multiply time
Converting negative time in Excel www.computing.net/answers/office/converting-negative-time-in-excel/8288.html

Excel - Calculating time between su www.computing.net/answers/office/excel-calculating-time-between-su/3978.html

i want to open different excel file www.computing.net/answers/office/i-want-to-open-different-excel-file/2461.html