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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Need to convert a 4 byte interger "1704" to a time "17:04". How do I do it.
 
TimeValueFrom4DigitInteger=
TimeSerial([4DigitInteger] \ 100, [4DigitInteger] MOD 100, 0)

(assuming the positional value of the last 2 digits is less than 60)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert GMT Date & Time 6
How to Convert MBOX to PST Online? 3
Which is the best MBOX Converter Tool different formats conversion? 5
CONVERT TIME FROM 4:30 TO 4.5 2
Access SQL Function to Convert Seconds to HH:MM 2
how to convert the bytes to word document in ms access database 1
Integer or Byte Data Type? 2
Convert imported text to date time 2

Back
Top