Converting decimal to time

[Drstein99]

I'm using an access report to convert a decimal number to time format. like if it were:

 

number time (convert to)

8.25 8:30

10.75 10:45

87.5 87:30

 

 

The problem I'm running is when I use:

 

FORMAT(myDecimal)/24,"h:nn")

 

it gets lost when there are more than 24 hours for it to translate. Any ideas?

[Robby]

You can do DateDiff() with minutes but again messes up when past 24.

 

Another way is to substring the numbers on the right of the semi-colon : and divide them by 60

 

ie 10:45 would be

 

45 / 60 = .75

 

result = 10.75

[Drstein99]

I'm trying to convert the DECIMAL number TO HHHH:MM

[Robby]

I guess the opposite would work..

 

ie 10.75 would be

 

.75 * 60 = :45

[Drstein99]

I had to create a function in the module section of access, that does the converting. looks like it's a vb6 vba interface.