Click here to Skip to main content
16,021,976 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
GeneralRe: error in use edit control and EndDialog() !!! Pin
Code-o-mat29-Sep-09 21:58
Code-o-mat29-Sep-09 21:58 
GeneralRe: error in use edit control and EndDialog() !!! Pin
KarstenK30-Sep-09 1:17
mveKarstenK30-Sep-09 1:17 
Question_variant_t vItem = pRange->Item[ iRow ][ iCol ]; [modified] Pin
MsmVc29-Sep-09 20:19
MsmVc29-Sep-09 20:19 
AnswerRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Franck Paquier29-Sep-09 23:12
Franck Paquier29-Sep-09 23:12 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc29-Sep-09 23:14
MsmVc29-Sep-09 23:14 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Richard MacCutchan29-Sep-09 23:56
mveRichard MacCutchan29-Sep-09 23:56 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc30-Sep-09 0:17
MsmVc30-Sep-09 0:17 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Richard MacCutchan30-Sep-09 1:12
mveRichard MacCutchan30-Sep-09 1:12 
MsmVc wrote:
i am getting 0.500138888888889


This is the internal Excel date and time format. I cannot remember the exact details but I think the datetime is in the form D.S, where D is the number of days since the 'epoch'*, and S is number of seconds since midnight divided by 86,400 (the total number of seconds in a day).

So in your case to get the time we multiply 0.500138888888889 by 86,400 which gives 43,212 or 12 hours, 0 minutes and 12 seconds.

*epoch is the base date from which counting starts. I think Excel may start at year zero.
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc30-Sep-09 1:34
MsmVc30-Sep-09 1:34 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc30-Sep-09 2:07
MsmVc30-Sep-09 2:07 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Richard MacCutchan30-Sep-09 3:34
mveRichard MacCutchan30-Sep-09 3:34 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc30-Sep-09 18:43
MsmVc30-Sep-09 18:43 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Franck Paquier30-Sep-09 19:10
Franck Paquier30-Sep-09 19:10 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc30-Sep-09 19:33
MsmVc30-Sep-09 19:33 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Franck Paquier30-Sep-09 20:00
Franck Paquier30-Sep-09 20:00 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc30-Sep-09 20:08
MsmVc30-Sep-09 20:08 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Franck Paquier30-Sep-09 20:37
Franck Paquier30-Sep-09 20:37 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc30-Sep-09 20:42
MsmVc30-Sep-09 20:42 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Franck Paquier30-Sep-09 21:43
Franck Paquier30-Sep-09 21:43 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
Franck Paquier30-Sep-09 21:45
Franck Paquier30-Sep-09 21:45 
GeneralRe: _variant_t vItem = pRange->Item[ iRow ][ iCol ]; Pin
MsmVc30-Sep-09 23:03
MsmVc30-Sep-09 23:03 
Questionhtml help and ms front-page Pin
includeh1029-Sep-09 19:24
includeh1029-Sep-09 19:24 
AnswerRe: html help and ms front-page Pin
Hans Dietrich29-Sep-09 20:19
mentorHans Dietrich29-Sep-09 20:19 
QuestionWhere is regedit.exe located in Pocket PC? Pin
Le@rner29-Sep-09 19:03
Le@rner29-Sep-09 19:03 
AnswerRe: Where is regedit.exe located in Pocket PC? Pin
Game-point29-Sep-09 19:14
Game-point29-Sep-09 19:14 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.