Excel - Convert int value secs past midnight into time 53100=2:45

  • Follow


How do convert an int value of seconds past midnight into a time value?  
Example: 53100 = 2:45PM
0
Reply Utf 5/27/2010 9:30:28 PM

Hi,

with your seconds in a1

=A1/(24*60*60)
and format as time (hh:mm:ss)


-- 
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that 
introduces the fewest assumptions while still sufficiently answering the 
question.


"Zuly" wrote:

> How do convert an int value of seconds past midnight into a time value?  
> Example: 53100 = 2:45PM
0
Reply Utf 5/27/2010 8:49:51 PM


Divide by the number of seconds in a day, as in:
=a1/86400
Format as a time.

Regards,
Fred

"Zuly" <Zuly@discussions.microsoft.com> wrote in message 
news:DAB64785-D6EF-43F6-9A10-2B0E0669B7CE@microsoft.com...
> How do convert an int value of seconds past midnight into a time value?
> Example: 53100 = 2:45PM 

0
Reply Fred 5/27/2010 10:49:35 PM

2 Replies
1292 Views

(page loaded in 3.764 seconds)


Reply: