If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Excel - Convert int value secs past midnight into time 53100=2:45
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

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

#1
May 27th 10, 10:30 PM posted to microsoft.public.excel.worksheet.functions
 Zuly external usenet poster 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
 Fred Smith[_4_] external usenet poster 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

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post Excel - Convert int value secs past midnight into time 53100=2:45 Mike H Excel Worksheet Functions 0 May 27th 10 09:49 PM Calculate hours, past midnight etc CindyJ Excel Worksheet Functions 4 January 14th 10 05:40 PM subtracting time going backwards past midnight? Billman Excel Worksheet Functions 3 March 9th 08 01:21 PM Calculating time past midnight. mailrail Excel Discussion (Misc queries) 3 April 18th 07 07:39 PM Calculating Time Past Midnight Darren Excel Worksheet Functions 6 March 13th 06 03:03 PM

All times are GMT +1. The time now is 08:45 PM.