|
![]() |
#1 |
Premium
Datum registracije: Oct 2006
Lokacija: Germany
Postovi: 694
|
MS Access, vrijeme vece od 24h (trebam pomoc)
pronasao sam nesto na internetu ali neznam to primjeniti, trebam nekog tko se malo bolje kuzi u access da mi pomogne kako da ovo dolje iskoristim za svoju tablicu!? ______________________________________________________________ You want Access to store HOURS and MINUTES, while the Date/Time field type stores DATES and TIMES. Any time over 24:00 is not valid. Here's a suggestion: define your fields as Double, and store the total number of minutes. (A Double field can hold a number up to 2,147,483,647.) Then prepare a couple of functions to get your data in and out, formatted as you like. For example, this function will accept the minutes and convert to hours and minutes in the format hhhh:mm. You'll need to write one that converts the other way so you can give it hhhh:mm and it will return the total minutes. Public Function MinutesToHM(incoming As Double) As String MinutesToHM= Int(incoming / 60) & ":" & _ Format(Int((incoming) - (Int(incoming / 60) * 60)), "00") End Function _______________________________________________________________ |
![]() |
![]() |
|
|
Oglas
|
Oglasni prostor
|
![]() |
|
|