M
mailme
i have time value like
A 01:44 and to convert into seconds
B 104
how to do it
urgent
A 01:44 and to convert into seconds
B 104
how to do it
urgent
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
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
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
M
mailme
Pete_UK said: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
B
Bob Phillips
=A1*1440
and format as General
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
and format as General
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
mailme said:Pete_UK said: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?