Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert time into seconds.
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...fo&userid=6746 View this thread: http://www.excelforum.com/showthread...hreadid=555706 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert time into seconds.
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...fo&userid=6746 View this thread: http://www.excelforum.com/showthread...hreadid=555706 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert time into seconds.
With a1 containing your 6:11:17
In b1 enter =A1*(60*60*24) "mangesh" wrote in message : 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...fo&userid=6746 View this thread: http://www.excelforum.com/showthread...hreadid=555706 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to convert time into seconds.
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...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=555706 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I convert seconds (up to 38,000) into HR:MN:SEC? | Excel Discussion (Misc queries) | |||
time sheet drop down lists | Excel Discussion (Misc queries) | |||
Convert decimal hour into time format? | Excel Discussion (Misc queries) | |||
how do I convert a date and time column to a time column | Excel Worksheet Functions | |||
The shortcut to enter time in excel should include seconds. | Excel Discussion (Misc queries) |