CPU time conversion

March 25, 2009 at 07:43:23
Specs: Windows XP
TIME is CPU 00:36:30.75 need a formula to convert to seconds and milliseconds for EXCEL

See More: CPU time conversion

Report •


#1
March 25, 2009 at 08:02:07
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


Report •

#2
March 25, 2009 at 08:16:41
Thanks MIke it formats but won't Chart.

Report •

#3
March 25, 2009 at 08:27:06
=HOUR(A1)*3600+MINUTE(A1)*60+SECOND(A1)

Report •

Related Solutions

#4
March 25, 2009 at 08:36:53
You may have to use VBA code or break apart your time.

Look here:

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

It might help.

MIKE


Report •


Ask Question