convert seconds into days
 

Hello, if someone can please help me with this, I would truly appreciate it.
Is there a way in Excel to compute the following question:
I would like to find out at what point in my life I lived 1 billion seconds.
I have to consider leap years as well. My birthday is July 5th, 1980.

Basically, I guess all I need to do is convert 1 billion seconds into days.

Please help!

convert seconds into days
 

You still have a few years to go!

A1 = 7/5/1980

=INT(A1+1E9/86400)

Format as date

If you want to know to the second then you'd have to enter the time of birth
in A1:

A1 = 7/5/1980 4:33 AM (I don't know if they record the seconds on a birth
certificate)

=A1+1E9/86400

Format as m/d/yyyy h:mm:ss AM/PM


--
Biff
Microsoft Excel MVP


"sross002" wrote in message
...
Hello, if someone can please help me with this, I would truly appreciate
it.
Is there a way in Excel to compute the following question:
I would like to find out at what point in my life I lived 1 billion
seconds.
I have to consider leap years as well. My birthday is July 5th, 1980.

Basically, I guess all I need to do is convert 1 billion seconds into
days.

Please help!

convert seconds into days
 

Should be 13th March 2012

This formula will do it. If you add your time of birth it will be more
accurate. (I also presume you are calling 1 billion, one-thousand million,
not one million, million, or you would be a lot older!

=DATE(1980,7,5)+(((1000000000/60)/60)/24)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.excelusergroup.org
web: www.nickhodge.co.uk





"sross002" wrote in message
...
Hello, if someone can please help me with this, I would truly appreciate
it.
Is there a way in Excel to compute the following question:
I would like to find out at what point in my life I lived 1 billion
seconds.
I have to consider leap years as well. My birthday is July 5th, 1980.

Basically, I guess all I need to do is convert 1 billion seconds into
days.

Please help!