slajoh01
asked on
Time Read-Out question on a TN3270 Emulator
For you programmers, I have this question which know one seems to know and I posted this on many many other forums and they do not know...I have this terminal emulator running on my Windows 2000 workstation called xioc3270tn which connects toa Mainframe running CICS applications and such. On the emulaotr's time read-out, heres what I noticed below here
12:48:55.68
My question is, what does the ( .68 ) stand for or mean in a emulator?
My guess, is this here below and can you guys confirm the answer for
me?
12:48:55:41
Because if you take .68 X 60 = 40.8. Am I right or wrong? So...Is my
example wrong or correct? Can you guys confirm this? And since it
equaled 40.8...I rounded it off by 41.
Can someone please post or explain a good answer for this matter please on the .68 means? Examples are needed please. And what increments are these last time digits are measured in? In other words, what comes after the .68 and so forth?
thanks
12:48:55.68
My question is, what does the ( .68 ) stand for or mean in a emulator?
My guess, is this here below and can you guys confirm the answer for
me?
12:48:55:41
Because if you take .68 X 60 = 40.8. Am I right or wrong? So...Is my
example wrong or correct? Can you guys confirm this? And since it
equaled 40.8...I rounded it off by 41.
Can someone please post or explain a good answer for this matter please on the .68 means? Examples are needed please. And what increments are these last time digits are measured in? In other words, what comes after the .68 and so forth?
thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
And I dont understand your computations here. You mean that I would take the 55 and ADD IT BY 68/100???
Im lost..
Si it should be like this?
55 + 68/100 seconds= 1.23?
Please explain...And what would be AFTER the .68? and so on, and so on, and so on?
thanks
Im lost..
Si it should be like this?
55 + 68/100 seconds= 1.23?
Please explain...And what would be AFTER the .68? and so on, and so on, and so on?
thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
55 + 68/100 seconds=1.23
55 + 68/100 seconds = 55.68 seconds
And what would be AFTER the .68
Add 0.01 - you get 0.69. Add 0.001 - you get 0.681
I really cannot explain this by other way, maybe you can ask in the Math forum :)
Seriously: sometimes we don't see really simple things trying to find something complicated. Maybe this happens to you now: just look at this number and forget everything except simple math from the school.
55 + 68/100 seconds = 55.68 seconds
And what would be AFTER the .68
Add 0.01 - you get 0.69. Add 0.001 - you get 0.681
I really cannot explain this by other way, maybe you can ask in the Math forum :)
Seriously: sometimes we don't see really simple things trying to find something complicated. Maybe this happens to you now: just look at this number and forget everything except simple math from the school.
I think the problem lies here:-
hh:mm:ss.cc
hh is a number in Radix 24
mm is a number in Radix 60
ss is a number in Radix 60
cc is a number in Radix 100
Why is the ':' separator used everywhere except for separating ss and cc?
The colon is indicating that these are not standard radix 10 numbers, and it is a *convention* with Time to express the delimiter as a colon. The reason for the dot is that the programmer that decided to represent parts of a second took it upon him/herself to express them in decimal notation, as opposed to Radix 60. Why? Because there is no subdivision of a second of Radix 60 that is in common use, and programming it is a darn sight easier using decimal than it is using Radix 60.
hh:mm:ss.cc
hh is a number in Radix 24
mm is a number in Radix 60
ss is a number in Radix 60
cc is a number in Radix 100
Why is the ':' separator used everywhere except for separating ss and cc?
The colon is indicating that these are not standard radix 10 numbers, and it is a *convention* with Time to express the delimiter as a colon. The reason for the dot is that the programmer that decided to represent parts of a second took it upon him/herself to express them in decimal notation, as opposed to Radix 60. Why? Because there is no subdivision of a second of Radix 60 that is in common use, and programming it is a darn sight easier using decimal than it is using Radix 60.
The following WikiPedia subjects may be of interest
http://en.wikipedia.org/wiki/ISO_8601
http://en.wikipedia.org/wiki/Unix_time
http://en.wikipedia.org/wiki/ISO_8601
http://en.wikipedia.org/wiki/Unix_time
ASKER
So again Im lost...What would be the .68 converted to?
Like this:
55 + 68/100 seconds=1.23
55 + 68/100 seconds = 55.68 seconds
I am still lost by this formula.....Which is it? Is it 1.23? or 55.68 seconds?
Like this:
55 + 68/100 seconds=1.23
55 + 68/100 seconds = 55.68 seconds
I am still lost by this formula.....Which is it? Is it 1.23? or 55.68 seconds?
ASKER
So is it 1/100 of a second or 10/100 of a second?
So if take 55 + 68/100 seconds=1.23....this is the right answer? Or, this below:
55 + 68/100 seconds = 55.68 seconds
I am still confused..
And is it 10/100 of a second? Or 1/100 of a second? Please give me another example please...I would appreciate it.
So if take 55 + 68/100 seconds=1.23....this is the right answer? Or, this below:
55 + 68/100 seconds = 55.68 seconds
I am still confused..
And is it 10/100 of a second? Or 1/100 of a second? Please give me another example please...I would appreciate it.
ASKER
And how would I do this formula in a Excel speadsheet adding the centiseconds there?
ASKER
My next question is, Is there ANYWAY ANY ANY way I can enter this "CENTISECONDS" in a Excel Spreadsheet as a TIME-NOW formula?
Because I want this to happen in all my spreadsheets is to include the 1/100 seconds..
How can do this? Thanks
Because I want this to happen in all my spreadsheets is to include the 1/100 seconds..
How can do this? Thanks
ASKER
I have two questions now.
1. How can ADD the "centiseconds" in a "Time-now()" formula in a Excel spreadsheet?
2. Again, I dont which one here is the correct conversion to do from the example you had posted? Below, which one is the correct way to do this? Because I see you have two? Why do you have two here and which one is the actual correct conversion below?
55 + 68/100 seconds=1.23
55 + 68/100 seconds = 55.68 seconds
1. How can ADD the "centiseconds" in a "Time-now()" formula in a Excel spreadsheet?
2. Again, I dont which one here is the correct conversion to do from the example you had posted? Below, which one is the correct way to do this? Because I see you have two? Why do you have two here and which one is the actual correct conversion below?
55 + 68/100 seconds=1.23
55 + 68/100 seconds = 55.68 seconds
ASKER
So what if I see this?? For example??
12:30:45.50
Would I convert the .50 like this???
45 + 50/100 = 0.95
Or, its wrong? I am lost...Sorry. I need a constant formula to convert the centiseconds...So how would MY example compare to yours above which I did?
Im lost.
12:30:45.50
Would I convert the .50 like this???
45 + 50/100 = 0.95
Or, its wrong? I am lost...Sorry. I need a constant formula to convert the centiseconds...So how would MY example compare to yours above which I did?
Im lost.
ASKER
So again...
1. What if I see some time like this in a TN3270 emulator?
12:30:45.50
How would I convert that?
And my SECOND question...would be how to use it in a spreadsheet in the TIME NOW formula??
I do want to add the 1/100 of a second in my spreadsheets...How can that be done?
1. What if I see some time like this in a TN3270 emulator?
12:30:45.50
How would I convert that?
And my SECOND question...would be how to use it in a spreadsheet in the TIME NOW formula??
I do want to add the 1/100 of a second in my spreadsheets...How can that be done?
> So again Im lost...What would be the .68 converted to?
It doesn't convert to anything. It is, as AlexFM's first post said:- 68/100 ths of a second.
>55 + 68/100 seconds = 55.68 seconds
Correct. It is 55.68 seconds
>45 + 50/100 = 0.95
No... 45 is 45 seconds. Adding 50 hundredths of a second to 45 seconds is going to give you:-
45+50/100 = 45+0.50
=45.50
0.45+50/100=0.95
Correct: you are adding hundredths of a second to hundredths of a second. The method of showing 0.45 is different to 45/100 but the *value* of 0.45 and 45/100 is identical.
Excel will display hundredths of a second if you format the cell with the following template:-
HH:MM:SS.00
It doesn't convert to anything. It is, as AlexFM's first post said:- 68/100 ths of a second.
>55 + 68/100 seconds = 55.68 seconds
Correct. It is 55.68 seconds
>45 + 50/100 = 0.95
No... 45 is 45 seconds. Adding 50 hundredths of a second to 45 seconds is going to give you:-
45+50/100 = 45+0.50
=45.50
0.45+50/100=0.95
Correct: you are adding hundredths of a second to hundredths of a second. The method of showing 0.45 is different to 45/100 but the *value* of 0.45 and 45/100 is identical.
Excel will display hundredths of a second if you format the cell with the following template:-
HH:MM:SS.00
ASKER
Ok...Can be kind enough to post another axample liike what if I see this:
12:45:44.11
Can post on how to do calculate that last time formula please?
12:45:44.11
Can post on how to do calculate that last time formula please?
ASKER
I did this in Excel and it will not show...ONLY the .00 will NOT move when I enter things....It only atays at .00
I did this m/dd/yy HH:MM:SS.00 like you said...But it everytime I enter something and hit enter...It will not move...It will stay at .00.
What IM doing worng? I went to format cells section were the time is...
I did this m/dd/yy HH:MM:SS.00 like you said...But it everytime I enter something and hit enter...It will not move...It will stay at .00.
What IM doing worng? I went to format cells section were the time is...
ASKER
So...what if I see something like this below?
12:45:44.11
44 + 11/100 = 44.11 seconds.....??? IS this correct?
2. Like I said....The excel thing will not work. I went to format cells, and entered date/time like this:
m/dd/yy HH:MM:SS.00
But everthing time I enter something like a letter and hit enter, the the .00 WILL NOT CHANGE..Any more suggestions? I even tried HH:MM:SS.CC but thats will not worked.
12:45:44.11
44 + 11/100 = 44.11 seconds.....??? IS this correct?
2. Like I said....The excel thing will not work. I went to format cells, and entered date/time like this:
m/dd/yy HH:MM:SS.00
But everthing time I enter something like a letter and hit enter, the the .00 WILL NOT CHANGE..Any more suggestions? I even tried HH:MM:SS.CC but thats will not worked.
>44 + 11/100 = 44.11 seconds.....??? IS this correct?
Yes it is
Excel:-
If you pull down Format, Cell, choose Custom. In the box it says General. Get rid of that. In its' place, type:-
HH:MM:SS.00
Say OK
Now, in that cell, if you type in:-
12:45:44.11
it will display as this, and you can do calculations with these values, so if you formatted cells A1, B1 and C1 up as I suggested, then put
12:45:44.11 in cell A1
12:45:44.12 in cell B1
and put =B1-A1 in cell C1, what result do you get in Cell C1?
Yes it is
Excel:-
If you pull down Format, Cell, choose Custom. In the box it says General. Get rid of that. In its' place, type:-
HH:MM:SS.00
Say OK
Now, in that cell, if you type in:-
12:45:44.11
it will display as this, and you can do calculations with these values, so if you formatted cells A1, B1 and C1 up as I suggested, then put
12:45:44.11 in cell A1
12:45:44.12 in cell B1
and put =B1-A1 in cell C1, what result do you get in Cell C1?
ASKER
I just want to use the Time Now in ONLY in ONE cell...Not more...
So in in A1...I got the TimeNow already...I selected Format Cells, than in the box below, I entered this...
m/dd/yy hh:mm:ss.00
And it does not worl. The .00 does not change at all..
So in in A1...I got the TimeNow already...I selected Format Cells, than in the box below, I entered this...
m/dd/yy hh:mm:ss.00
And it does not worl. The .00 does not change at all..
ASKER
And Im using StarOffice..Not excel which is a similar type spreadsheet..Thats why I posted in the Excel forums also because I think its the same functions...And theres no StarOffice forum area here.
ASKER
The digit that will change is the seconds...Thats it...NOT the .00..I tried everything....like you told me. And this is just ONLY in cell A-1, which I ONLY want to use as the date/time.....area. NOTHING else....
Like I said, I entered like this under USER DEFINED...
m/dd/yy hh:mm:ss.00
And the .00 WILL NOT change...
Like I said, I entered like this under USER DEFINED...
m/dd/yy hh:mm:ss.00
And the .00 WILL NOT change...
> I just want to use the Time Now in ONLY in ONE cell...Not more...
Maybe, but I am demonstrating to you how this works in the context of your original question.
What you are asking is beyond the scope of this question. I see you have asked this new question in the Excel section. Excel works in much the same way as StarOffice - I tested my thoughts out on Excel and OpenOffice which is a cut down version of Excel, and it works.
Maybe, but I am demonstrating to you how this works in the context of your original question.
What you are asking is beyond the scope of this question. I see you have asked this new question in the Excel section. Excel works in much the same way as StarOffice - I tested my thoughts out on Excel and OpenOffice which is a cut down version of Excel, and it works.
ASKER
IT DOES NOT WORK IN STAR-OFFICE 7... ONLY on VERSION 8....Thats the problem...
Problem solved...
It worked under Windows 2000 because I downloaded StarOffice 8 there....But in Solaris 10, StarOffice comes preloaded with version 7 which does NOT support the 1/100 seconds thing....
PROBLEMO SOLVED...
Thanks anyway!!!
Problem solved...
It worked under Windows 2000 because I downloaded StarOffice 8 there....But in Solaris 10, StarOffice comes preloaded with version 7 which does NOT support the 1/100 seconds thing....
PROBLEMO SOLVED...
Thanks anyway!!!
ASKER
But is there anyway to make it work on version 7 though??? Any suggestions?
Things should work better in a newer version than an older version#, so best to stick with the newer version.
#Not always guaranteed!
#Not always guaranteed!
Ditto the 1st response: AlexFM > 55.68 seconds = 55 + 68/100 seconds
in decimal. ##/100 trainslates in english to hundredths
in decimal. ##/100 trainslates in english to hundredths
AlexFM answered the question, I provided clarification on questions arising from the answer, so therefore may I suggest a split of points between us?
ASKER
I thought taking .68 X 60 = 40.8 (41) thought would be 12:48:44:41.
So, what be after the .68? What are the increments of measurements AFTER the .68?
Please explain?
So what whatever last decimal digit I see in the 3270 emulator, always has to be divided into 100? Or what?
Explain...And what would be after the .68?