Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Bob Phillips
 
Posts: n/a
Default

How odd, just like London buses ...

There is a UDF available at
http://www.mcgimpsey.com/excel*/udfs/unixtoxltime.html that does the
conversion.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Craig Walker" wrote in message
...
Hello Community:

I have two questions regarding Unix time. I have a number of calculations
that have unix time codes in them and I am trying to do the following:

1) Convert the unix time to normal time to display in Excel
2) Subtract one unix time from another and then have the difference

display
in SECONDS in Excel

Any thoughts or advice would be greatly appreciated.

Thanks,
Craig



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
How do you enter a negative time number in Excel? Thomas99 Excel Discussion (Misc queries) 4 March 17th 05 11:42 PM
can you date time stamp entries in excel opinky Excel Discussion (Misc queries) 1 March 17th 05 04:25 PM
opening 2 excel workbooks at the same time candulj Excel Discussion (Misc queries) 1 March 13th 05 10:57 PM
in excel totaling weekly hours military time mel Excel Worksheet Functions 1 January 17th 05 04:24 PM
how can i add time in excel? Marcus Excel Worksheet Functions 2 January 7th 05 08:17 PM


All times are GMT +1. The time now is 07:23 AM.

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

About Us

"It's about Microsoft Excel"