Sorry... I meant to post my message to the OP.

--
Rick (MVP - Excel)


"Rick Rothstein" wrote in message
...
In Excel, Time is the fraction of a day that has passed for the given time
(for example, 3:00 AM is 3/24 (or 0.125) of a 24-hour day.

To convert seconds (assumed to be in A1), use this... =A1/86400

To convert minutes (assumed to be in B1), use this... ==B1/1440

Custom Format the cells using this pattern... mm.ss.00 in the Type field.

Note: The 86400 comes from multiplying 24 (hours in a day) times 60
(minutes in an hour) * 60 (seconds in a minute); the 1440 comes from
multiplying 24 (hours in a day) times 60 (minutes in an hour).

--
Rick (MVP - Excel)


"Sheeloo" <="to" & CHAR(95) & "sheeloo" & CHAR(64) & "hotmail.com" wrote
in message ...
See http://www.cpearson.com/excel/datetime.htm

Let us know if you still need support.

"First Aid Computing" wrote:

Greetings. I have recently been handed a project dealing with process
times.
I have one set of numbers as seconds (ss.ssssssss) and one as a decimal
version of minutes (.91 m). What process do I need to know to convert
these
numbers into a workable format. I'm hoping to have them as mm:ss.ss and
then
doing basic math with the results. Thanks in advacne.