Printing values problem

Question

3.50/5 (2 votes)

See more:

Hi All,

In csv file, there is a string value(date)that appears as: 00:55.0 , but when clicked on that, 21:00:55 appears in the formula bar.

When I try to extract the value, the code :

C++

wchar_t *pStrTime    =  str3; // this variable holds the time value

When I run my program in debug, to check the values, this pStrTime takes 21:00:55, but when I print this using :

C++

wchar_t *pStrTime    =  str3; // this variable holds the time value  str.Format(_T("%s),pstrTime)

But when I print it, 00:55.0 is printed.

Why is that?

Posted 13-Jun-12 22:57pm

Sumal.V

Updated 14-Jun-12 0:47am

v2

Add a Solution

Comments

Richard MacCutchan 14-Jun-12 6:06am

How are you getting the value from the Excel worksheet?

Sumal.V 14-Jun-12 6:11am

Using swscanf_s function.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

krmed · Accepted Answer · 2012-06-14T00:42:00

If you're reading it with swscanf_s function, I'm going to guess that it really isn't an Excel file - perhaps a csv file (that will open in Excel by default).

As for the display in Excel showing 00:55.0 and the value appearing to be 21:00:55, you need to be aware that Excel attempts to be "smart" about reading your data. That is to say it attempts to format the data in a way that Excel thinks it should be - which is not always right.

If you click on that cell and format it with a custom format you will see different displays. For instance, that particular data appears to be a date/time, but also perhaps with milliseconds included, so set the custom format to "hh:mm:ss.000" (without the quotes) and you'll see something like 21:55:00.000 in Excel.

Hope this helps.