Thanks Fred, but this won't work because the data is coded in date format
even though it says minutes and seconds. So by multiplying 3:11 (formatted as
3:11 am) by 24 x 60 x 60, I came up with 9550 --way too much. The answer
should be 191 (3*60+11). I suppose I first have to get the apparent date
format to actual minutes and seconds.

"Fred Smith" wrote:

To convert a time to seconds, multiply by 24*60*60.

Regards,
Fred

"Midjack" wrote in message
...
I have a series of times (minutes, seconds) that I would like to convert to
equivalent numbers so they can be graphed. For example 3:11, 3 minutes, 11
seconds (stored as 3:11 am) to seconds (3 x 60 + 11 or 191) or 27:09:00,
27
minutes, 9 seconds (stored as 1/1/1900 3:09:00 AM) or 27 X 60 + 9 = 1629.
Can this be done...easily?

Thanks