convert minutes to seconds
 

I have a series of race times that are entered in minutes format (4:01) and I
want to convert to seconds in decimal format.

convert minutes to seconds
 

Hi,

Multiply by 24 and ensure the cell is formatted general.

Mike

"davidkandy" wrote:

I have a series of race times that are entered in minutes format (4:01) and I
want to convert to seconds in decimal format.

convert minutes to seconds
 

I think you'll have to multiply by at least another 60, as Mike's 24
converts from days (Excel's unit of time) to hours.
4:01 will be interpreted as hours and minutes, not minutes and seconds, so
if you intended 4:01 to be minutes and seconds, multiplying by 24*60 would
give you the number of seconds. If you have a time which is genuinely 4:01
in minutes and seconds (entered as 0:4:01 or as 4:01.0), then you'll need to
multiply by 24*60*60 to get from Excel time to decimal seconds.
--
David Biddulph

"Mike H" wrote in message
...
Hi,

Multiply by 24 and ensure the cell is formatted general.

Mike

"davidkandy" wrote:

I have a series of race times that are entered in minutes format (4:01)
and I
want to convert to seconds in decimal format.