LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bruce
 
Posts: n/a
Default How to combine milliseconds with date/time reference and display?

I am trying to combine a date/time reference (B10) with another column (C10)
containing milliseconds. I would like to display the date/time and the
milliseconds in another column (D10) like dd/mm/yyyy hh:mm:ss.000.

I have tried the following, but none seems to work:
=DATEVALUE(B10)+TIMEVALUE(B10)+TIME(0,0,C10)
=B10+TIME(0,0,C10)

Both formulas result appears the same as the reference time in B10 even
after selecting the custom format of dd/mm/yyyy hh:mm:ss.000.

Appreciate a suggestion.

Thanks,
Bruce

 
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
Display the cell reference of the cell that is currently selected. Emlou85 via OfficeKB.com Excel Worksheet Functions 5 March 18th 06 10:29 AM
how to get excel to display blank if reference cell blank silent1(not) Excel Worksheet Functions 1 December 2nd 05 02:49 PM


All times are GMT +1. The time now is 12:53 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"