mm:ss to ss
 

i have time value like

A 01:44 and to convert into seconds

B 104

how to do it


urgent


--
mailme
------------------------------------------------------------------------
mailme's Profile: http://www.excelforum.com/member.php...o&userid=32928
View this thread: http://www.excelforum.com/showthread...hreadid=527511

mm:ss to ss
 

Times are stored internally in Excel as fractions of a 24 hour day. To
convert an Excel time format into seconds, then, you just need to
multiply by 60, by 60 again and by 24, i.e.:

=A1 *60*60*24

and format the cell as number with 0 dp.

Hope this helps.

Pete

mm:ss to ss
 

Pete_UK Wrote:
Times are stored internally in Excel as fractions of a 24 hour day. To
convert an Excel time format into seconds, then, you just need to
multiply by 60, by 60 again and by 24, i.e.:

=A1 *60*60*24

and format the cell as number with 0 dp.

Hope this helps.

Pete


common man it doesn't work out]


my data in format

1:44
5:33
3:55

now i need to convert into seconds only

not sighn of minute

like final solution to be

104
333
223


the error that shows on prevois is #name?


--
mailme
------------------------------------------------------------------------
mailme's Profile: http://www.excelforum.com/member.php...o&userid=32928
View this thread: http://www.excelforum.com/showthread...hreadid=527511

mm:ss to ss
 

=A1*1440

and format as General

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mailme" wrote in
message ...

Pete_UK Wrote:
Times are stored internally in Excel as fractions of a 24 hour day. To
convert an Excel time format into seconds, then, you just need to
multiply by 60, by 60 again and by 24, i.e.:

=A1 *60*60*24

and format the cell as number with 0 dp.

Hope this helps.

Pete


common man it doesn't work out]


my data in format

1:44
5:33
3:55

now i need to convert into seconds only

not sighn of minute

like final solution to be

104
333
223


the error that shows on prevois is #name?


--
mailme
------------------------------------------------------------------------
mailme's Profile:
http://www.excelforum.com/member.php...o&userid=32928
View this thread: http://www.excelforum.com/showthread...hreadid=527511