Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate hours, past midnight etc CindyJ Excel Worksheet Functions 4 January 14th 10 06:40 PM
Macro / function text time to 24hr excel time passed midnight fortotaling hr's Russmaz Excel Worksheet Functions 2 March 6th 09 05:58 AM
subtracting time going backwards past midnight? Billman Excel Worksheet Functions 3 March 9th 08 02: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 04:03 PM


All times are GMT +1. The time now is 11:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"