convert minute to short time

[balahawy]

Hi all i have a problem i have field contains (minutes as number) like 5750 i want to convert thes minutes to short time hh :nn to be 95:50

 

[balahawy]

any idea i want to solve it

 

[JHB]

Try the below code:

Format(YourFieldName \ 60, "00") & ":" & Format(YourFieldName Mod 60, "00")

 

[spikepl]

You cannot. In Access time is "time of day", and Short Time therefore cannot go beyond 24 hours. You need to calculate the amount of hours and minutes and construct a string yourself:

DIm MyShortTime As String
MyShortTime=Format(NumberOfHours,"00") & ":" & Format(NumberOfMinutes,"00")