convert seconds into days

  • Thread starter Thread starter sross002
  • Start date Start date
S

sross002

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!
 
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
 
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
(e-mail address removed)
web: www.excelusergroup.org
web: www.nickhodge.co.uk
 
Back
Top