Computing.Net > Forums > Programming > CPU time conversion

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

CPU time conversion

Reply to Message Icon

Name: RICK32250
Date: March 25, 2009 at 07:43:23 Pacific
OS: Windows XP
Subcategory: Batch
Comment:

TIME is CPU 00:36:30.75 need a formula to convert to seconds and milliseconds for EXCEL



Sponsored Link
Ads by Google

Response Number 1
Name: Mike (by mmcconaghy)
Date: March 25, 2009 at 08:02:07 Pacific
Reply:

Not sure this will work, but you could try something like:

Custom Format

hh:mm:ss.000


Also, Excel questions are best asked in the Office Software section.

MIKE


0

Response Number 2
Name: RICK32250
Date: March 25, 2009 at 08:16:41 Pacific
Reply:

Thanks MIke it formats but won't Chart.


0

Response Number 3
Name: reno
Date: March 25, 2009 at 08:27:06 Pacific
Reply:

=HOUR(A1)*3600+MINUTE(A1)*60+SECOND(A1)


0

Response Number 4
Name: Mike (by mmcconaghy)
Date: March 25, 2009 at 08:36:53 Pacific
Reply:

You may have to use VBA code or break apart your time.

Look here:

http://www.ozgrid.com/forum/showthr...

It might help.

MIKE


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More


arrays's size findstr and copy the line



Post Locked

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


Go to Programming Forum Home


Sponsored links

Ads by Google


Results for: CPU time conversion

Conversion of C++ into Fortran www.computing.net/answers/programming/conversion-of-c-into-fortran/8003.html

A fixed percent CPU usage applicati www.computing.net/answers/programming/a-fixed-percent-cpu-usage-applicati/12902.html

Classes... again :) www.computing.net/answers/programming/classes-again-/10926.html