Hi all,

I have a db that records time in the minutes that have passed midnight.

I need to pull this back and put it into correct time hh:mm

Can anyone help me with setting up the initial time to midnight??

Thanks in Advance,

Simon

do you mean format it?

Format(TheReturnedTime, "HH:MM")

Or do you want to add time?

dim d as new date(year, month, day, hour, minute, second)

Then you can add minutes...

d = d.addminutes(NumberOfMinutes)

Or you need the difference in two dates:

dim d as Date = DateDiff(DateInterval, Date1, Date2)

I have a db that records time in the minutes that have passed midnight.

I need to pull this back and put it into correct time hh:mm

Can anyone help me with setting up the initial time to midnight??

Thanks in Advance,

Simon

I want the format to be HH:MM no days month or year just the time and
set to midnight in the code

There is no time class so I would use the date class. You just don't use the
year, month, or day. Only use them to delcare the date, but after that, you
can use the hours, minutes, and seconds.

VB2005:
dim d as date = Today

VB2003:
dim d as date = Now.Today

-----
d will equal December 12, 2006 at midnight.

I want the format to be HH:MM no days month or year just the time and
set to midnight in the code

what is a static property and a cursor question
how to save the textbox contents to sql server database
Not understanding simple concept
Updating Datagridview
Newbie
VB.NET debug error
Need help with CreateFile API function
mutex
need convert a value (integer) into bytearray with bits 0-31
Installed version of Access