Excel - Convert int value secs past midnight into time 53100=2:45
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 |
All times are GMT +1. The time now is 12:35 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com