convert minutes and seconds (in a date format) to numbers
When you enter n:nn into Excel, it assumes hours and minutes, not minutes
and seconds. As you seem happy with this, just multiply by 24*60 to get
"seconds". Remember, under this method, to display more than 24 "minutes"
you will need to use the format [h]:mm
Regards,
Fred
"Midjack" wrote in message
...
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
|