Convert 4 byte integer to time (hh:mm)?

's Computer Specifications

Need to convert a 4 byte interger "1704" to a time "17:04". How do I do it.

's Computer Specifications

TimeValueFrom4DigitInteger=
TimeSerial([4DigitInteger] \ 100, [4DigitInteger] MOD 100, 0)

(assuming the positional value of the last 2 digits is less than 60)

--
HTH
Van T. Dinh
MVP (Access)

"JEB" <(E-Mail Removed)> wrote in message
news:AEB145C7-A4BD-4E07-BE34-(E-Mail Removed)...
> Need to convert a 4 byte interger "1704" to a time "17:04". How do I do
> it.

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert Integer to Byte Array?	Christian Reizlein	Microsoft VB .NET	1	19th May 2008 03:20 AM
How do i convert a byte[2] with format big endian signed int to a integer value?	eywitteveen@gmail.com	Microsoft C# .NET	3	30th Sep 2007 09:11 PM
How to convert a byte array to a singe integer	Star	Microsoft C# .NET	5	9th May 2007 01:40 AM
Re: How to convert integer(long) to byte array?	Larry Lard	Microsoft VB .NET	1	7th Jul 2005 06:07 AM
Re: Convert Integer to Byte Array	Jon Skeet [C# MVP]	Microsoft Dot NET	0	27th Jul 2004 07:37 PM