Prev: Date Help
Next: Fill last row down for large selection?
From: Zuly on 27 May 2010 17:30
How do convert an int value of seconds past midnight into a time value?
Example: 53100 = 2:45PM
From: Fred Smith on 27 May 2010 18:49
Divide by the number of seconds in a day, as in:
=a1/86400
Format as a time.

Regards,
Fred

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

 | 
Pages: 1
Prev: Date Help
Next: Fill last row down for large selection?