Remember Me?

#1
May 27th 10, 10:30 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: May 2010 Posts: 1
Excel - Convert int value secs past midnight into time 53100=2:45

How do convert an int value of seconds past midnight into a time value?
Example: 53100 = 2:45PM

#2
May 27th 10, 11:49 PM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jan 2008 Posts: 2,389
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
news
How do convert an int value of seconds past midnight into a time value?
Example: 53100 = 2:45PM

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Mike H Excel Worksheet Functions 0 May 27th 10 09:49 PM CindyJ Excel Worksheet Functions 4 January 14th 10 06:40 PM Billman Excel Worksheet Functions 3 March 9th 08 02:21 PM mailrail Excel Discussion (Misc queries) 3 April 18th 07 07:39 PM Darren Excel Worksheet Functions 6 March 13th 06 04:03 PM

All times are GMT +1. The time now is 08:58 AM.