Tags: convert, converted, example, excel, microsoft, msdn, seconds, software, time, timing
How to convert time into seconds.
On Microsoft » Microsoft Excel
2,437 words with 3 Comments; publish: Thu, 22 May 2008 18:21:00 GMT; (30662.50, « »)
Hi,
Can someone please let me know how to convert timing into "seconds".
For example if timing is 6:11:17 it should be converted into "Seconds".
--
mangesh
---
mangesh's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6746
View this thread: http://www.excelforum.com/showthread.php?threadid=555706
http://excel.itags.org/q_microsoft-excel_240908.html
All Comments
Leave a comment...
- 3 Comments
- hi,
try
=hour(a1)*3600+minute(a1)*60+second(a1)
hth
regards from Brazil
Marcelo
"mangesh" escreveu:
> Hi,
> Can someone please let me know how to convert timing into "seconds".
> For example if timing is 6:11:17 it should be converted into "Seconds".
>
> --
> mangesh
>
> ---
> mangesh's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6746
> View this thread: http://www.excelforum.com/showthread.php?threadid=555706
>
#1; Thu, 22 May 2008 18:22:00 GMT
- With a1 containing your 6:11:17
In b1 enter =A1*(60*60*24)
"mangesh" <mangesh.2a0v3z_1151346602.1541.excel.itags.org.excelforum-nospam.com> wrote
in message news:mangesh.2a0v3z_1151346602.1541.excel.itags.org.excelforum-nospam.com:
> Hi,
> Can someone please let me know how to convert timing into "seconds".
> For example if timing is 6:11:17 it should be converted into "Seconds".
>
> --
> mangesh
>
> ---
> mangesh's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=6746
> View this thread: http://www.excelforum.com/showthread.php?threadid=555706
#2; Thu, 22 May 2008 18:23:00 GMT
- Jim's formula would give you 22277 in another cell (using your example).
Alternatively you could just format your original cell(s) with a custom
format of
[s]
daddylonglegs
---
daddylonglegs's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30486
View this thread: http://www.excelforum.com/showthread.php?threadid=555706
#3; Thu, 22 May 2008 18:24:00 GMT