Excel - Convert int value secs past midnight into time 53100=2:45
Divide by the number of seconds in a day, as in:
=a1/86400
Format as a time.
Regards,
Fred
"Zuly" wrote in message
...
How do convert an int value of seconds past midnight into a time value?
Example: 53100 = 2:45PM
|