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

  • Thread starter Thread starter Zuly
  • Start date Start date
Z

Zuly

How do convert an int value of seconds past midnight into a time value?
Example: 53100 = 2:45PM
 
Divide by the number of seconds in a day, as in:
=a1/86400
Format as a time.

Regards,
Fred
 
Back
Top