Convert time in number of seconds

's Computer Specifications

Hi,

How can a convert the time into number of seconds.

For Eg

12:30:45 = 45045

Does any one know the formula. I have writen a macro for it but if
there is a formula it will be helpful.

Regards
Heera

's Computer Specifications

=A2*24*60*60
or =A2*86400
and format as general or number.

Excel stores time in days, and there are 24 hours in a day, 60 minutes in an
hour, & 60 seconds in a minute.
--
David Biddulph

"Heera" <(E-Mail Removed)> wrote in message
news:72576a68-99ff-4329-a3d0-(E-Mail Removed)...
> Hi,
>
> How can a convert the time into number of seconds.
>
> For Eg
>
> 12:30:45 = 45045
>
> Does any one know the formula. I have writen a macro for it but if
> there is a formula it will be helpful.
>
> Regards
> Heera

's Computer Specifications

thank u....it worked perfectly....

You gave me good logic.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to convert number in to time lenght, minutes and seconds?	Bojan	Microsoft Excel Misc	3	3rd Nov 2008 07:35 AM
convert time string to number of seconds	tony	Microsoft C# .NET	4	15th Jun 2006 04:06 PM
How do i convert a number of seconds to a date/time?	=?Utf-8?B?TWFyZ28=?=	Microsoft Excel Worksheet Functions	2	5th Jan 2005 12:09 AM
convert a number of seconds to HH:MM:SS?	Steff_DK	Microsoft Excel Programming	2	18th Jun 2004 10:42 PM
convert number of seconds to date	gordon_conroy	Microsoft Excel Misc	5	29th Jan 2004 06:45 AM