ne 1 know how to ignore hour? using vb.net
the server sent msg to me:
Amsterdam.NL.EU.undernet.org 317 djanjo djanjo 9 1091798232 :seconds
idle, signon time
TextBox1.Text = TimeSerial(0, 0, 9) ===> 12:0:09 AM
this mean supra has been 9 second idle.......but i don't want hour
been showing
Amsterdam.NL.EU.undernet.org 317 djanjo djanjo 1954 1091798232 :seconds
idle, signon time
TextBox1.Text = TimeSerial(0, 0, 1954) ===> 12:32:34 AM
this mean supra has been 32 min :34 sec idle
but again i don't want hour been showing
Amsterdam.NL.EU.undernet.org 317 djanjo djanjo 1954 1091798232 :seconds
idle, signon time
TextBox1.Text = TimeSerial(0, 0, 5954) ===> 1:39:14 AM
i have been 1 hr:39 min:14 sec ............************** that fine
with me*********
does ne 1 know how to ingnore hour?
regards
2  2039 
Ever thought about using TimeSpan instead of TimeSerial?
"Supra" <su*****@rogers.com> wrote in message
news:Eg**********************@twister01.bloor.is.n et.cable.rogers.com... ne 1 know how to ignore hour? using vb.net
the server sent msg to me:
Amsterdam.NL.EU.undernet.org 317 djanjo djanjo 9 1091798232 :seconds
idle, signon time
TextBox1.Text = TimeSerial(0, 0, 9) ===> 12:0:09 AM
this mean supra has been 9 second idle.......but i don't want hour
been showing
Amsterdam.NL.EU.undernet.org 317 djanjo djanjo 1954 1091798232 :seconds
idle, signon time
TextBox1.Text = TimeSerial(0, 0, 1954) ===> 12:32:34 AM
this mean supra has been 32 min :34 sec idle
but again i don't want hour been showing
Amsterdam.NL.EU.undernet.org 317 djanjo djanjo 1954 1091798232 :seconds
idle, signon time
TextBox1.Text = TimeSerial(0, 0, 5954) ===> 1:39:14 AM
i have been 1 hr:39 min:14 sec ............************** that fine
with me*********
does ne 1 know how to ingnore hour?
regards
hi nick ,
i solved probled using format.
ex: TextBox1.Text = Format(TimeSerial(0, 0, 5954), "hh:mm:ss") ==>
1hrs:39min:14 sec .................that fine
but TextBox1.Text = Format(TimeSerial(0, 0, 1954), " mm:ss") ==>
32min:34 sec
the timespan wouldn't do too much coding.
regards
Nick Malik wrote: Ever thought about using TimeSpan instead of TimeSerial?
"Supra" <su*****@rogers.com> wrote in message
news:Eg**********************@twister01.bloor.is. net.cable.rogers.com...
ne 1 know how to ignore hour? using vb.net
the server sent msg to me:
Amsterdam.NL.EU.undernet.org 317 djanjo djanjo 9 1091798232 :seconds
idle, signon time
TextBox1.Text = TimeSerial(0, 0, 9) ===> 12:0:09 AM
this mean supra has been 9 second idle.......but i don't want hour
been showing
Amsterdam.NL.EU.undernet.org 317 djanjo djanjo 1954 1091798232 :seconds
idle, signon time
TextBox1.Text = TimeSerial(0, 0, 1954) ===> 12:32:34 AM
this mean supra has been 32 min :34 sec idle
but again i don't want hour been showing
Amsterdam.NL.EU.undernet.org 317 djanjo djanjo 1954 1091798232 :seconds
idle, signon time
TextBox1.Text = TimeSerial(0, 0, 5954) ===> 1:39:14 AM
i have been 1 hr:39 min:14 sec ............************** that fine
with me*********
does ne 1 know how to ingnore hour?
regards
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Lapchien |
last post by:
My table has a record called date/time - filled (not surprisingly) with a
date and time. I can format the date in one query field, also the time,
using format in an expression. My user wants me...
|
by: Shyguy |
last post by:
I am working on an application in which the end user will enter a
time, Say 3:00 PM, and a number, say 5
I want to create a number of records (5) as follows,
3:00:00
3:00:01
3:00:02
3:00:03...
|
by: Supra |
last post by:
ne 1 know how to ignore hour? using vb.net
the server sent msg to me:
Amsterdam.NL.EU.undernet.org 317 djanjo djanjo 9 1091798232 :seconds
idle, signon time
TextBox1.Text = TimeSerial(0, 0, 9)...
|
by: Farcot |
last post by:
I compute timeby TimeSerial function
TimeSerial(intTime / 100, intTime Mod 100, 0)
I get 11:00:00 for intTime=1100. After daylight saving was changed to summer
I start to get 12:00:00 for...
|
by: Tee GEE |
last post by:
I included my VBA below. I would like to change the font of the
"strBody" to be Bold, italic, color, etc. The code that I attempted to
write is identified by ***. Any help would be appreciated....
|
by: Luvin lunch |
last post by:
Hi,
I'm new to access and am very wary of dates as I have limited
experience in their manipulation and I know if they're not done
properly things can turn ugly quickly.
I would like to use a...
|
by: divya |
last post by:
What is an equivalent TimeSerial() function of VBscript in the Java
Script??
I have two variables hour and minutes.
Timeserial(hour,minutes) returns the time hour : minutes.
But I want to do...
|
by: Rickster66 |
last post by:
Hey there,
I have a reporting issue and any help is well appreciated. I have been requested to create a report based on cells (defined a groups of workers). So far, so good. The report is be be...
|
by: jrayjr |
last post by:
Hello,
I have a access query that reads in 2 time fields but its not in time format. Example: 900, 1300, 256, 2245, etc. What I am trying to do is driver comes in at 900(9:00AM) and leaves...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |
